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

354 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
equates16201232(None) 
eluates72014681eluates
equate152012461equate_
equated171910401equated
equites162212491equites
coequates2045852coequates
educates1139622educates
elates65032362e_lates
eluate62315432eluate_
elutes64020312elu_tes
emulates10312572emulates
enates64026432e_nates
equaled17166922equaled
equals1538702equa_ls
equator1637482equator
equators1737472equators
equines161811592equines
equities17310772equities
ergates8314492ergates
estates74520182estates
exudates1636622exudates
liquates1737452liquates
quakes194013342_quakes
quartes163314942_quartes
quate144521412_quate_
quatres163411942_quatres
quotes153312462_quotes
requites171511762requites
squares163714462squares
squats153712962squat_s
abates85825043_abates
ablates92416913ablates
actuates10310313actuates
acuate8315633acuate_
acutes83917723acu_tes
adequate1844303adequate_
adulates9311913adulates
aerates74627503aerates
agates76121343_agates
agnates82813193agnates
alates64833973_alates
annates72415423annates
aquae142212713aqua_e_
aquas142412613aqua__s
aquatic1838113aquatic
aquatics1945893aquatics
aquatones1844843aquatones
ates45047923___ates
aviates10313083aviates
bates75846343__bates
bedmates1349193bedmates
bequeaths2341773bequeaths
berates94126883berates
borates94823023borates
brutes86118683bru_tes
butes714535873_bu_tes
buttes84822563_buttes
carates95630613carates
cates75951893__cates
caudates11310263caudates
cerates95428253cerates
chutes114615773chu_tes
coequate1946153coequate_
coequated2144823coequated
comates114123643comates
crates85736063_crates
creates95225213creates
curates95323833curates
cutes79438323_cu_tes
dates65639153__dates
dealates92716683dealates
debates103718533debates
deflates123013943deflates
delates83526283delates
denudates1145583denudates
depurates1239823depurates
deputes104911783depu_tes
derates84028893derates
deviates12312753deviates
dilates83220663dilates
diquats1745983diquat_s
donates83217223donates
eases56041613e__ases
eaten55323053e__aten
eater54639843e__ater
eaters65535953e__aters
eats47054873e__at_s
eaves85231993e__aves
ecartes94212563ecartes
eclats8313033eclat_s
ectases92911673ectases
educate10310213educate_
educated1237943educated
educes94011953edu_ces
educts9439893educt_s
effaces15277273effaces
elate55335883e_late_
elated74725823e_lated
elater64724203e_later
elaters74420193e_laters
elevates111110433elevates
elites66027123e_lites
eluants737583eluants
eludes75417683elu_des
elute54822573elu_te_
eluted74915263elu_ted
eluviates1246113eluviates
emanates10311333emanates
emeutes938013emeutes
emirates101214853emirates
emotes84620283e_motes
empales112411433empales
emulate9314123emulate_
emulated11310793emulated
enate54428153e_nate_
encages103313783encages
encases93116053encases
endites83717063endites
enfaces122110913enfaces
engages92912493engages
enlaces92313393enlaces
enquires17276973enquires
enrages83114853enrages
entases72816273entases
enures63919713enu_res
epilates10313503epilates
equable1849253equable
equably2136183equably
equal1449823equa__l
equalise1748213equalise
equalises1847253equalises
equalities1949013equalities
equalizes2747693equalizes
equalled1834863equalled
equally1936873equally
equating18310113equating
equation17310483equation
equations1839493equations
equids16439143equ_ids
equine151711573equine_
equipages2143123equipages
equips17387193equ_ips
equity1838103equit_y
erases64425403e_rases
ergate7315143ergate_
erratas736863erratas
ersatzes1743073ersatzes
eructates1146953eructates
eructed10228653eructed
eructs83610793eruct_s
erupted10207173erupted
erupts8348903erupt_s
escapes113811673escapes
escuages1145163escuages
esquires17266213esquires
estate64719763estate_
estated83715573estated
etapes85415293e_tapes
ethanes103713513ethanes
etudes73811603etu_des
evacuates14256803evacuates
evades1039023e_vades
evaluates12247353evaluates
evites94916483e_vites
evulses1035043evulses
excites16310633excites
exhales1737143exhales
expats1537683expat_s
expiates17810213expiates
extubates1844843extubates
exudate1537093exudate_
exudes143710363exu_des
exulted1536303exulted
exults13257633exult_s
exuviates1945383exuviates
eyases94513683e_yases
fates85139233__fates
fellates11312753fellates
ferrates113013423ferrates
fixates1737393fixates
flutes95421783flu_tes
folates103218453folates
gates65939513__gates
gelates83219593gelates
gemmates13307673gemmates
gestates93213733gestates
glutes74517673glu_tes
grates75429893_grates
gyrates113610263gyrates
hamates122917683hamates
hates86742573__hates
humates122813193humates
ideates8313733ideates
ingates82716913ingates
inmates92715783inmates
iodates8312903iodates
jutes125125133_ju_tes
karates115617473karates
legates82917683legates
ligates82318383ligates
liquate1638423liquate_
liquated1835493liquated
locates93218813locates
loquats1645273loquat_s
lutes55836663_lu_tes
luxates1436973luxates
lysates10317473lysates
malates93522613malates
mates75251363__mates
mediates112814073mediates
mesquites20476433mesquites
metates92720013metates
mezquites29374023mezquites
mutates92215793mutates
mutes75033783_mu_tes
nates55238333__nates
negates83215843negates
neonates8310063neonates
nidates8311893nidates
notates72817483notates
nutates73214973nutates
oblates91913243oblates
oleates7417833oleates
opiates9312143opiates
orates64328613_orates
ovulates1148523ovulates
palates93624943palates
pates76047893__pates
pectates122213953pectates
peculates132112543peculates
penates93321603penates
pirates93020333pirates
plates85432243_plates
prates84633163_prates
pupates113311433pupates
qats135331343_q_at_s
quacks214710103_quacks
quads154515843_qua_ds
quaeres163310853_quaeres
quaffs21125693_quaffs
quags154613253_qua_gs
quails153412643_quails
quais144618393_qua_is
quake184114643_quake_
quaked203910033_quaked
quaker193811623_quaker
quakers20309703_quakers
quale143617853_quale_
qualms17317243_qualms
quanted1738973_quanted
quants153614143_quants
quare143920543_quare_
quarks193810913_quarks
quarte154115333_quarte_
quarter163211863_quarter
quarters173110463_quarters
quartet162814903_quartet
quartets17277583_quartets
quartos16328743_quartos
quarts154715943_quarts
quartzes2645463_quartzes
quashes192110973_quashes
quass144413763_qua_ss
quasses16209503_quasses
quatre153512363_quatre
quaver18309313_quaver
quavers19309023_quavers
quays174612043_qua_ys
qubytes2134383_qubytes
queues153510193_queues
quiets154014373_quiets
quintes164114713_quintes
quires154015753_quires
quite144621463_quite_
quits144122353_quit_s
quotas15339433_quotas
quote143714773_quote_
quoted16359453_quoted
quoter153510093_quoter
quoters16369273_quoters
rates55352013__rates
rebates95123193rebates
recrates102420383recrates
redates83423883redates
reflates113115673reflates
refutes104515733refu_tes
regrates92618413regrates
regulates101211723regulates
relates73731443relates
remates93827123remates
replates102919283replates
reputes94615963repu_tes
requires17168703requires
requite162012483requite_
requited18169723requited
requiter17168643requiter
requiters18176553requiters
reslates83619513reslates
restates83423443restates
rotates72819773rotates
routes66129313rou_tes
sates54949323__sates
sautes63924913sau_tes
savates10312953savates
scutes85219193scu_tes
seaquakes2282823seaquakes
sedates83418043sedates
senates73322613senates
sensates8511143sensates
seriates82620683seriates
serrates82617023serrates
shutes93518223shu_tes
sinuates8310963sinuates
situates8310373situates
skates104219403_skates
slates64934063_slates
solates73523853solates
spates85028173_spates
squabs17429323squa_bs
squads164410293squa_ds
squalls1647313squalls
squamates2045593squamates
square154513363square_
squared173610563squared
squarer163410663squarer
squarers17338033squarers
squarest17338223squarest
squarks20417183squarks
squashes20207803squashes
squat143720143squat__
squatly1946433squatly
squatness1844943squatness
squatted1835343squatted
squatter1735913squatter
squatters1834953squatters
squattest1844613squattest
squatty1964823squatty
squawks23294883squawks
squaws18438783squa_ws
squires163812843squires
states64337083_states
suites63727403_suites
tates55444983__tates
testates83615453testates
toluates8138903toluates
ululates848433ululates
unquotes1745353unquotes
updates10329793updates
uprates93814863uprates
urates65027763_urates
utes45930883__u_tes
vacates12312833vacates
valuates112811203valuates
zouaves1933893zouaves

Search took 8 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.423422437.4
2DLD Change Limit1340273546.54620474.6
3Display Results3543540.1262809.5
 (SQL Overall)1786913547.09525185.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.