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

210 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
echoey1439785(None) 
echoed125211151echoed
echoer114011101echoer
echoes114715521echoes
chokey184811712_chokey
choky175711222_choky
cooey105828222_cooey
eche97520282ech_e_
eched116919222ech_ed
eches106322162ech_es
echo96615952echo__
echoers12459692echoers
echoic1339042echoic
echos105216462echo_s
ethoxy1933922ethoxy
ache96829823ach_e_
ached119227833ach_ed
aches106132293ach_es
achier113914263achier
achoo10315083acho_o
achy126316093ach__y
ahoy101919183_aho_y
anchovy1843953anchovy
blooey115110793blooey
cagey115917823_cagey
cakey145517273_cakey
chary135023133_chary
chay124924873_ch_ay
cheek145115713_cheek
cheeky18448613_cheeky
cheep125416503_cheep
cheer105420383_cheer
cheery144913153_cheery
cheesy14419193_cheesy
chef125125623_ch_ef
chevy16479993_chevy
chew126622133_ch_ew
chewy165011903_chewy
chez184519023_ch_ez
chief134419483_chief
chiel104918973_chiel
chivy164810363_chivy
chock164316613_chock
choir105313603_choir
choke145118023_choke
choked164914793_choked
choker154314373_choker
chokes154917383_chokes
chola104718033_chola
choler113717153_choler
cholo105217973_cholo
chomp144815663_chomp
chon96627793_cho_n
chook146015043_chook
choosey15459233_choosey
choosy14459103_choosy
chop116024923_cho_p
choppy18376293_choppy
chops125019873_chops
chord115917263_chord
chore105126763_chore
chorea115216083_chorea
chored125321883_chored
chores114828023_chores
chose105925403_chose
chosen116014133_chosen
choses115825133_choses
chott103923933_chott
chow125820993_cho_w
chowed154914653_chowed
chows135618203_chows
chromy16309903_chromy
cloy96623833_clo_y
coed77140543_c_oed
coky137526823_c_oky
coly96940533_c_oly
coney105932883_coney
cony96537833_c_ony
cooed84534343_cooed
cooee74531023_cooee
cooer74831013_cooer
cooeys114914483_cooeys
cookey155414333_cookey
cooky145321363_cooky
cooly105525423_cooly
copy116229803_c_opy
cory96941513_c_ory
cosey106226713_cosey
cosy97232703_c_osy
covey136121783_covey
cowy126427363_c_owy
coy810557553_c_o_y
cozey196718543_cozey
cozy185823803_c_ozy
crony105918673_crony
cutey105819793_cutey
decoy115716313dec_o_y
ebony104511513e_bony
echard1249223echard
eching126315563eching
echini114710433echini
echoing1358613echoing
echoism1447363echoism
echoless1345603echoless
echt95722903ech__t
ecology13218823ecology
economy1445433economy
eddoes8199143eddoes
embody1435033embody
emboly1336723emboly
enjoy1545963enjo_y
envoy1156723envo_y
ephod1139123epho_d
ephods1238363ephods
ephor10310013epho_r
ephori1139603ephori
ephors11311403ephors
epoxy17465773e_poxy
eschew1436333esch_ew
etched123613703etch_ed
etcher113912943etch_er
etches114217763etch_es
ether84518773eth_er
ethos85514193etho_s
ethoses10311763ethoses
ethoxyl2042353ethoxyl
euchre11137663euchre_
euchred13106163euchred
euchres1288663euchres
eulogy1035633eulogy
euphony1545403euphony
euroky1334823euroky
exhort16410803exhort
flooey123910173flooey
geckoes14325793geckoes
gooey95522863_gooey
hey96741063__h_ey
hoe67562723__hoe_
hoed87837983__hoed
hoer76533983__hoer
hoes75755733__hoes
hokey155422183__hokey
holey115626903__holey
holy106333433__holy
homey135924843__homey
homy126623223__homy
honey115629913__honey
hooey114926603_hooey
hosey116127023__hosey
hoy97447913__ho_y
ichor1039483icho_r
ichors11310423ichors
joey145719333__joey
leched123716003lech_ed
lecher113415853lech_er
lechery15257643lechery
leches115421313lech_es
lechwe1435113lechwe_
lechwes1535063lechwes
looey84822913_looey
mahoe10315573mahoe_
mahoes11313103mahoes
methoxy2243943methoxy
ocher104516103och_er
ochery14319443ochery
ochone11311293ochone
ochre103411593ochre_
ochrea11316643ochrea
ochred12328003ochred
ochres113510833ochres
ochry13346933och_ry
peched144915343pech_ed
phoney143612983_phoney
phony136715443_phony
phooey14379233phooey
ptooey11346413ptooey
rechew14310213rech_ew
rechose121312043rechose
rechosen13127033rechosen
recopy1339043rec_opy
rectory123512723rectory
reechoed1436083reechoed
reechoes1338413reechoes
reshoe92816483reshoe_
reshoed112212153reshoed
reshoes102316033reshoes
scarey115016983scarey
schizy23115043schizy
schlep1347093schlep
schmoe13328333schmoe_
schmoes14308543schmoes
school11410723school
schorl1179803schorl
shoe75933443_shoe_
shoed95723013_shoed
shoer84722163_shoer
shoes85429663_shoes
showy145714013_showy
sooey84522433_sooey
teched124014433tech_ed
techie11511723techie_
techier1269243techier
techies12513603techies
techily1537123techily
techy135612013tech__y
they107223753_th_ey
unholy1238163unholy
whey135018713_wh_ey
yechy16519083yech__y
zooey173914803_zooey

Search took 10 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.753237305.4
2DLD Change Limit1127162109.04612460.3
3Display Results2102100.0633333.3
 (SQL Overall)1786912109.86218119.1
 
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.