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 “reecho” 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.

204 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
reecho1131865(None) 
reechy14367821reechy
beech124315502beech_
beechy16397502beechy
breech13348262breech_
echo96615952__echo
leech104913212leech_
rancho114310852rancho
reach105123882reach_
recto74520802r_ecto
reechoed1436082reechoed
reechoes1338412reechoes
retch104818302retch_
ancho104515303_ancho
beach124623893beach_
beachy164011253beachy
beechen14367703beechen
beeches143413883beeches
belch124415503belch_
bench125619503bench_
breach134213723breach_
breeched16337383breeched
breeches15258673breeches
broncho14206463broncho
concho134414263concho
creche13310763creche
creesh11328333creesh_
deco76125973_dec_o
dreich12377723dreich_
drench12369593drench_
each95530583_each_
eche97520283__eche
echos105216463__echos
echt95722903__echt
erect74129333erec_t
erector93513803erector
erects84116183erects
etch95419143_etch_
fetch134913473fetch_
fleche14299303fleche
fleech14367343fleech_
french143511213french_
fresco1136473fresc_o
gaucho1256223gaucho
gecko124511113_gecko
heuch135312333heuch_
heuchs14447923heuchs
honcho14389383honcho
kench145513923kench_
kerchoo1644973kerchoo
ketch144912023ketch_
leach105422523leach_
leachy14419733leachy
lech96825443_lech_
leeched13369503leeched
leeches123911933leeches
letch105215803letch_
macho126120153_macho
merch125417963merch_
mucho125013443_mucho
nacho105414383_nacho
outecho1244893outecho
peach125422493peach_
peachy164510843peachy
pech116125453_pech_
pechs125516203_pechs
perch124518833perch_
poncho133310123poncho
preach133613923preach_
preachy17307313preachy
psycho1674533psycho
ranch105019793ranch_
ranchos123911393ranchos
ratch104221363ratch_
reached134619083reached
reacher123718293reacher
reaches123423203reaches
react74634333reac_t
reactor93011653reactor
reacts83616603reacts
rebato83714683rebato
rebec94416543rebec__
rebeck14419913rebec_k
rebecks15288013rebecks
rebecs103913673rebec_s
rebozo1737323rebozo
rec55645463r_ec__
recap95718023r_ecap
recce9514563r_ecce
recces10614913recces
recede95515533recede
recent83630853recent
recept103319073recept
recess8314263recess
rechew14310213r_echew
rechose121312043r_echose
recit75235103r_ecit
reck106130563r_ec_k
reckon123010543r_eckon
recks115625133r_ecks
recon75624243r_econ
recook125513923r_ecook
recs65734183r_ec_s
recta74220263r_ecta
recti73619623r_ecti
rector84019743r_ector
rectos85718783r_ectos
recur74116843r_ecur
recut74729243r_ecut
redcap1158493redcap
redo56029363r_e_do
ree37974073ree___
reearn6612143reearn
reechier1336673reechier
reechoing1545293reechoing
reed55549623ree__d
reeded84022563reeded
reedit7617223reedit
reeds65430903ree_ds
reedy910020283ree_dy
reef74938213ree__f
reefed103816583reefed
reefer93314363reefer
reefs85121663ree_fs
reefy114217703ree_fy
reek85232523ree__k
reeked113717643reeked
reeker103715593reeker
reeks94124033ree_ks
reeky125416263ree_ky
reel45240533ree__l
reeled74725533reeled
reeler63822573reeler
reels55333263ree_ls
reemit8717223reemit
reendow11285063reendow
reenjoy1743293reenjoy
rees45364193ree__s
reest54938093ree_st
reests64618893reests
reeve84121323ree_ve
reeved104118713reeved
reeves94721493reeves
refect114319333refec_t
refects124012743refects
reject154116283rejec_t
rejector17237723rejector
rejects163910693rejects
repo66027543r_e_po
repro75315913r_epro
reschool1344133reschool
rescue8313003rescue
resect84424703resec_t
resects94115593resects
resh76523453r_esh_
reshod103012233r_eshod
reshoe92816483r_eshoe
reshot93519633r_eshot
reshow123111433r_eshow
retched133814273retched
retches123318513retches
reteach1237413reteach_
retro55020953r_etro
reverso10367693reverso
rezero1578873rezero
rho65924833r___ho
rich97025543r_ich_
roach105717003roach_
rotch105815933rotch_
rotche114311983rotche
rouche114714313rouche
ruche104216763r_uche
screech1435213screech_
screechy1842763screechy
secco9312423_secco
seethe93712483seethe
seiche11811833seiche
senecio947203senecio
speech1347563speech_
subecho1445073subecho
teach105221123teach_
tech95925443_tech_
techno1135953_techno
techs106915833_techs
techy135612013_techy
teeth87315853teeth_
teethe94511313teethe
telco7511873telc_o
tench105620003tench_
tetchy1436003tetchy
teuch105214853teuch_
trench114211613trench_
velcro1144133velcro
vetch134411843vetch_
wecht13415443_wecht
welch134411493welch_
wench136214783wench_
wrench14439353wrench_
wretch14326533wretch_
yecch15558093yecch_
yecchs16414953yecchs
yech127220533_yech_
yechs136112583_yechs
yechy16519083_yechy

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162046.50017340.9
3Display Results2042040.0633238.1
 (SQL Overall)1786912046.70326658.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.