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

311 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
equating1831011(None) 
equaling1837791equaling
aquatint1749432aquatint
coequating2245322coequating
eating75134402e__ating
educating1337932educating
elating83423082e_lating
eluting84115292elu_ting
emulating1239872emulating
equalling1945242equalling
equation17310482equation
equations1839492equations
eructing112110172eructing
erupting11218442erupting
estating92614992estating
exulting1637642exulting
liquating1946312liquating
quaking2139312_quaking
quanting1849232_quanting
quoting17310042_quoting
requiting1939882requiting
squaring18158632squaring
squatting1934512squatting
abating10413973_abating
ablating11311993ablating
abutting1137003abutting
actuating1239223actuating
adulating1178713adulating
aerating92821003aerating
aqualung1842183aqualung
aquatic1838113aquati_c
aquatics1945893aquatics
aquatints1844033aquatints
aquatone1744913aquatone
aviating12311013aviating
bating95132253__bating
beating104326873_beating
bequeathing2651573bequeathing
berating113220763berating
bleating113514503bleating
bloating113512813bloating
blunting11319843blunting
blurting11258773blurting
boating103721303_boating
borating113414503borating
bruiting11259973bruiting
bruting102612993bru_ting
bunting103718833_bunting
busting104221793_busting
butting103519283_butting
cheating144014523cheating
chuting132910733chu_ting
cleating113518133cleating
coating103525313_coating
counting113115273counting
courting112514573courting
crating103725203_crating
creating113921953creating
crusting113612793crusting
curating11314293curating
cutting103817493_cutting
dating85326483__dating
daunting103310403daunting
dauting93814763dau_ting
debating123213733debating
debuting12268633debu_ting
deducting1436843deducting
defeating142311973defeating
deflating142610713deflating
degusting1236163degusting
delating103119603delating
denudating1345263denudating
depurating1438643depurating
deputing12238793depu_ting
derating103222283derating
deviating14311083deviating
dilating102714903dilating
doating93816863_doating
donating10311803donating
doubting1237373doubting
ducting113713593_ducting
dueting93814393_dueting
dunting93418383_dunting
dusting93618993_dusting
earing75235483e__aring
easing74926463e__asing
easting84924303e_asting
eatings84616443e__atings
editing9313133e_diting
educing1137683edu_cing
effacing1744463effacing
egesting1039013egesting
ejecting18268163ejecting
electing112113783electing
elevating1338203elevating
eluding93412113elu_ding
eluviating1444893eluviating
emanating1239003emanating
embaying1635263embaying
emitting112410353emitting
emoting10313563e_moting
empaling1338363empaling
enacting11311363enacting
encaging1258733encaging
encasing11610823encasing
enditing10311073enditing
enfacing1467293enfacing
engaging1147373engaging
enlacing1148773enlacing
enquiring19175443enquiring
enraging1049573enraging
enuring8813883enu_ring
epilating12310963epilating
equalise1748213equalise
equalising2065993equalising
equality2046993equality
equalize2648023equalize
equalizing2967463equalizing
equate152012463equat__e
equated171910403equat_ed
equates162012323equat_es
equational1945603equational
equator1637483equat_or
equators1737473equators
equine151711573equ__ine
equipping2342843equipping
equitant1746923equitant
equities17310773equities
erasing8317963e_rasing
erecting112415063erecting
eructating1345693eructating
escaping1347063escaping
escoting1158713escoting
esquiring19174023esquiring
essaying1235033essaying
evacuating1645673evacuating
evading1237283e_vading
evaluating1456013evaluating
everting122213133everting
evicting1437483evicting
eviting11511373e_viting
evulsing1234733evulsing
exacting1838523exacting
exalting1638033exalting
exciting1838023exciting
exerting162211153exerting
exhaling1936293exhaling
existing1639073existing
exiting15311393e_xiting
expiating1938543expiating
extubating2044423extubating
exuding16347443exu_ding
exuviating2144523exuviating
fating105328673__fating
faulting12237733faulting
fellating1339243fellating
fixating1936183fixating
floating123111883floating
fluting113815093flu_ting
fruiting12229063fruiting
gating84826953__gating
gelating103015733gelating
gemmating1576443gemmating
gestating11229983gestating
gloating102611463gloating
glutting10247643glutting
grating93923183_grating
grunting10269583grunting
gusting93917163_gusting
gutting93415923_gutting
gyrating1337453gyrating
hating104929713__hating
haunting123510053haunting
heating114024323_heating
hunting114317123_hunting
hurting113914033_hurting
hutting113016033_hutting
ideating10311703ideating
iodating1038823iodating
jaunting16328633jaunting
jousting16309353jousting
justing153615163_justing
jutting153313713_jutting
legating102313113legating
ligating102212283ligating
locating11311503locating
louting83719383lou_ting
lunting83817743_lunting
lusting83619323_lusting
luting75221753_lu_ting
luxating1645613luxating
mating94832913__mating
mediating13311203mediating
moating104218153_moating
moulting112710313moulting
mounting112711813mounting
munting103718773_munting
musting103221073_musting
mutating112211753mutating
muting93921523_mu_ting
negating102012833negating
nidating1039783nidating
notating92513343notating
nutating92411953nutating
nutting83316233_nutting
opiating11410093opiating
orating83520323_orating
ousting84021353_ousting
outing74128153_ou_ting
ovulating1336953ovulating
peculating1549153peculating
pirating11314513pirating
plating103823073_plating
pleating112916053pleating
pouting103519943pou_ting
prating103424453_prating
punting103318443_punting
pupating1337683pupating
putting103218573_putting
quacking2436743_quacking
quadding2035363_quadding
quaffing2434353_quaffing
quailing1838403_quailing
quaint15415173_qua_int
quantong1843493_quantong
quashing2137093_quashing
questing1838273_questing
queuing1736233_queuing
quieting18228463_quieting
quilting18218713_quilting
quiring17159993_quiring
quirting18238383_quirting
quitting18228833_quitting
quoiting1836093_quoiting
rating74938703__rating
rebating112418343rebating
rebutting1237523rebutting
recoating121317463recoating
recrating121318793recrating
recutting1239483recutting
redating102620173redating
reflating132514713reflating
refuting121911903refu_ting
regrating111316213regrating
regulating12310063regulating
reheating132314913reheating
relating92725443relating
relucting1239773relucting
remating112322413remating
repeating122618983repeating
replating122217403replating
reputing112412603repu_ting
requesting2046313requesting
requiring1937043requiring
reseating102421533reseating
reslating102516993reslating
restating102319413restating
resulting10311083resulting
roqueting1944603roqueting
rotating92614553rotating
rousting93913273rousting
routing83821093rou_ting
rusting83821263_rusting
rutting82718043_rutting
sating74735453__sating
seating84130683_seating
sedating103014113sedating
sensating1039253sensating
sequining1945323sequining
seriating10916403seriating
serrating10513203serrating
shunting123610433shunting
shuting113212053shu_ting
shutting12309693shutting
sinuating1039683sinuating
situating1038883situating
skating123613853_skating
slating83724653_slating
smutting11278063smutting
solating9315593solating
spurting113111633spurting
squadding2143233squadding
squalling1935173squalling
squashing2234703squashing
squawking2642433squawking
squeaking2334213squeaking
squealing1935153squealing
squinting1936223squinting
squiring18177563squiring
squirting1934793squirting
stating83725163_stating
stunting92811503stunting
suiting83419003_suiting
sweating123213023sweating
taunting93510933taunting
tauting83316383tau_ting
touting84118453tou_ting
treating92519613treating
truanting1035603truanting
trusting93411653trusting
tufting11289873_tufting
tutting83515913_tutting
ululating1036643ululating
unquaking2354593unquaking
unquoting1944763unquoting
updating1236593updating
uprating11311113uprating
vacating14310353vacating
valuating1338643valuating
vaulting12227223vaulting
vaunting12338753vaunting

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 Filter1786911461620.420425454.8
2DLD Change Limit1461623116.34323043.0
3Display Results3113110.1432174.8
 (SQL Overall)1786913116.90625874.7
 
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.