Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “lynched” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

249 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
lynched1637675(None) 
lunched133911821lunched
lyncher15366551lyncher
lynches15378871lynches
synched16277211synched
benched154713942benched
blanched16308602blanched
blenched16358052blenched
bunched154312412bunched
cinched153910862cinched
clenched16257762clenched
clinched16347382clinched
flenched17267962flenched
flinched17316702flinched
glunched1544262glunched
hunched163710492hunched
inched124514482_inched
lanced93717722lanc_ed
latched133914072latched
launched1475402launched
leached133715042leached
leched123716002l_eched
leeched13369502leeched
letched133912052letched
luncher123111412luncher
lunches124115442lunches
lurched13358032lurched
lychee143710892ly_chee
lyches144213612ly_ches
lynch13468982lynch__
lynchers16285452lynchers
munched153411072munched
pinched153812452pinched
punched153512172punched
ranched133113602ranched
synced12266962sync_ed
wenched163910912wenched
winched163110592winched
ached119227833__ached
arched125717323_arched
bached145519893_bached
batched154114243batched
beached154516553beached
belched154011843belched
bencher144113483bencher
benches143918603benches
birched15349913birched
bitched153212923bitched
blancher15338633blancher
blanches153311603blanches
bleached16378563bleached
blencher15308393blencher
blenches153310763blenches
blotched1635653blotched
botched153611903botched
branched163210453branched
brunched16317853brunched
bunches144116033bunches
buncoed12378443buncoed
cached145419203_cached
cinches144215773cinches
clencher15277973clencher
clenches152910953clenches
cliched153711023cliched
clincher15347663clincher
clinches153910363clinches
clutched16356033clutched
coached153313843coached
conches144019813conches
couched154115793couched
cranched163210413cranched
crunched16328163crunched
cycled1436543cy_cled
danced105315253danc_ed
ditched143711903ditched
douched144012113douched
drenched15247913drenched
dunches133312583dunches
eched116919223__eched
etched123613703_etched
fancied133310603fancied
fenced124412713fenc_ed
fetched163710473fetched
filched16307423filched
finches153914193finches
fleeched17345823fleeched
flenches163410533flenches
fletched17306693fletched
flincher16256583flincher
flinches16358953flinches
flitched17256293flitched
flysches1933123flysches
frenched17299433frenched
glanced11439233glanc_ed
glunches1436263glunches
hatched163414463hatched
haunched1744813haunched
hitched163312253hitched
honchoed1745733honchoed
hotched163610923hotched
hunches153913463hunches
hutched16359883hutched
incher114114033_incher
inches114419673_inches
itched123812023_itched
kenches163912273kenches
kythed17407313ky_thed
laced87132643l_ac_ed
laches116528353l_aches
lacked135324653l_acked
lanated8313203lanated
lance75126723lanc_e_
lancer84319973lanc_er
lances84824103lanc_es
lancet84223573lanc_et
lanceted1137073lanceted
landed84619243lan_ded
larchen12479633larchen
larches124416453larches
lashed105625213l_ashed
latches123320133latches
latchet123117913latchet
lathed104718463l_athed
laughed1235893laughed
launcher1365563launcher
launches1387903launches
leacher124014843leacher
leaches123319343leaches
leashed113211163leashed
lecher113415853l_echer
leches115421313l_eches
leeches123911933leeches
lenited8812433lenited
lensed74015473len_sed
letches124015483letches
lichee114017973l_ichee
lichen114012743l_ichen
liches114724293l_iches
lichted13268803l_ichted
licked134621563l_icked
lined64934643lin__ed
linked114518213lin_ked
linseed838203linseed
linted74021823lin_ted
loaches123613983loaches
loathed11419443loathed
locked134921663l_ocked
locoed94312193l_ocoed
longed87121373lon_ged
longhead1345083longhead
louche115212663louche_
lucked135118023l_ucked
lunated8310823lunated
lunch104917243lunch__
luncheon1344013luncheon
lunchers13349563lunchers
lunged85418273lun_ged
lunkhead1642963lunkhead
lunted74517523lun_ted
lurcher12338133lurcher
lurches123311663lurches
lushed104218723l_ushed
lycea10418943ly_c_ea
lycee104716743ly_c_ee
lycees11428863ly_cees
lych126015763ly_ch__
lychees15516783ly_chees
lyncean1292923lyncean
lynching17336083lynching
lynchpin1842273lynchpin
lynxes1634323lyn_xes
lyrated11388473lyrated
lysed95011563ly__sed
manche133515103manche_
manches143818623manches
manchet143317783manchet
marched153813403marched
matched153513963matched
miched143913393_miched
minced114114913minc_ed
mooched153910533mooched
mouched153612593mouched
mulched15307763mulched
muncher143610373muncher
munches144215793munches
niched125514063_niched
notched134210303notched
ouched124316933_ouched
parched154013693parched
patched153514623patched
paunched1645523paunched
peached154315883peached
peched144915343_peched
perched154713243perched
pincher143812713pincher
pinches144117933pinches
pitched153512923pitched
planche14299753planche_
planches153111863planches
planchet152511963planchet
pleached16338063pleached
plenches153110623plenches
poached154212403poached
ponced114314813ponc_ed
ponchoed1646133ponchoed
pooched152810083pooched
pouched153612773pouched
psyched1843913psyched
puncher143311673puncher
punches144816133punches
quenched2334103quenched
rancher123013633rancher
ranches123620113ranches
reached134619083reached
retched133814273retched
roached133211833roached
ruched124314633_ruched
slouched14206743slouched
stanched14208903stanched
synch135011793synch__
synchro1544543synchro
synchs14408453synch_s
teched124014433_teched
tenches123515523tenches
tetched133010773tetched
tincted1037273tincted
torched133511363torched
touched134914963touched
trenched14289853trenched
tyned95915013tyn__ed
tythed13457503ty_thed
unshed10313773_unshed
vouched163910563vouched
watched163012823watched
welched16298833welched
wencher153811133wencher
wenches152914133wenches
winced124415343winc_ed
wincher153410653wincher
winches154714373winches
witched163012193witched
wrenched17748133wrenched
wyches17387913wy_ches
yachted1634853_yachted
yacked164516793_yacked
yocked164114423_yocked
yucked164013563_yucked
zinced18419413zinc_ed
zincked2334233zincked

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.403443402.0
2DLD Change Limit1340272496.14321817.8
3Display Results2492490.0932677.4
 (SQL Overall)1786912496.63926915.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.