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

508 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
cautery1234957(None) 
cattery123811601cattery
acutely1246122acutely
acuter84412862acuter_
artery9911452_artery
battery124911812battery
cannery123610012cannery
canter85230112canter_
canters94827722canters
carter84932272carter_
carters95327242carters
caster85232572caster_
casters94729892casters
cater74840702ca_ter_
caters85336492ca_ters
causer84117782causer_
causers94014782causers
causey113513272cause_y
chattery16357272chattery
clattery13378192clattery
clustery13317102clustery
cluttery13346312cluttery
couter84930202couter_
couters93827282couters
cutely115312802c_utely
cuter74728222c_uter_
cutesy114810732c_utesy
cutey105819792c_ute_y
cutlery12448392c_utlery
daubery13396212daubery
eatery95316352ea_tery
gaudery1234742gaudery
mastery124214322mastery
mattery123810712mattery
tauter64318022tauter_
wastery134610992wastery
watery123914492wa_tery
actuary1245613actuary
acute74720363acute__
acutes83917723acute_s
acutest94410603acutest
adultery1244223adultery
aery77231683_a__ery
after85719793_after_
afters94717073_afters
alter54828503_alter_
alters64924223_alters
ambery133811133_ambery
apery106517903_a_pery
apter76120203_apter_
apteryx1942383_apteryx
aster55434893_aster_
astern64815813_astern
asters65631603_asters
auger64922473_auger_
augers73818703_augers
augury10366663_augury
austere7312993_austere
autarky1444703_autarky
auteur6107943_auteur
auteurs7137503_auteurs
baiter84422553baiter_
baiters94619303baiters
bakery155911003ba_kery
banter84825333banter_
banters94623113banters
barter85525373barter_
barters94223033barters
baster85333593baster_
basters94930303basters
batter84928873batter_
batters94626013batters
blustery13368003blustery
bootery1238983bootery
brutely1235933brutely
butlery12369423_butlery
buttery124311193buttery
caber95126833ca_ber_
cabers105023903ca_bers
cabler104519173cabler_
cablers114416713cablers
cachexy2443283cachexy
cadger105013893cadger_
cadgers114711993cadgers
cager85229223ca_ger_
cagers95624183ca_gers
cagey115917823ca_ge_y
cagier93715933cagier_
cahier113615773cahier_
cahiers123510673cahiers
cajolery20253573cajolery
cakey145517273ca_ke_y
cakier123115243cakier_
caldera1037963caldera
calker124917083calker_
calkers134414693calkers
caller85125483caller_
callers94221963callers
calmer105216933calmer_
calory11312843ca_lory
calvary1537183calvary
camber124418473camber_
cambers134017433cambers
camera10313673ca_mera
camper124722213camper_
campers134220283campers
canary11314693ca_nary
cancer104220923cancer_
cancers114018583cancers
caner75334773ca_ner_
caners84629193ca_ners
canker124422523canker_
cankers134418753cankers
canner84625983canner_
canners93822663canners
canoer85121073canoer_
canoers94318373canoers
canonry1235923canonry
canted94825783cante_d
canteen9411083canteen
cantered113415983cantered
cantor85621523cantor_
cantors94620753cantors
canty105226803cant__y
caper94831623ca_per_
capers105428133ca_pers
capper124421983capper_
cappers134419403cappers
captor104914603captor_
captors113914983captors
capture1138903capture
carder94524183carder_
carders104820353carders
career85822243career_
careers95218783careers
carer74942333ca_rer_
carers85133953ca_rers
carney115315703carne_y
carper104923633carper_
carpers114521253carpers
carry105823783ca__rry
carte75940423carte__
carted98631443carte_d
cartel85022533carte_l
cartels94618123cartels
cartes86239473carte_s
carver114420143carver_
carvers124817533carvers
casefy1436273ca_sefy
casern84713313ca_sern
caste75932363caste__
castes85631863caste_s
castor84418533castor_
castors94919433castors
catchy16559583ca_tchy
cate66254593ca_te__
category1443823ca_tegory
catena8312473ca_tena
catenary1346583ca_tenary
cateran9313763ca_teran
catered103117763ca_tered
caterer92815933ca_terer
cates75951873ca_te_s
catted95422473catte_d
cattier93317073cattier_
cattily123210853cattily
catty104520413ca_t_ty
caudex1636393caude_x
caules85927253caule_s
caulker13456893caulker_
caulkers14375643caulkers
cause75225353cause__
caused95117043cause_d
causerie1078263causerie
causes88026473cause_s
causeway1643253causeway
causeys12387223causeys
cauterant1148523cauterant
cauteries11615363cauteries
cauterize2088303cauterize
caution93013513caution
cavalry1554963cavalry
caver105629063ca_ver_
cavern115312453ca_vern
cavers115026833ca_vers
cavitary1664963cavitary
celery1139623c_elery
cemetery1554923cemetery
center84421413center_
centers94420593centers
century1237193century
chancery18366653chancery
chanter123919733chanter_
chanters134016723chanters
chantey154112543chante_y
chantry15388213chant_ry
chapter144213853chapter_
chapters154012113chapters
charter123918303charter_
charters134115563charters
chastely1635813chastely
chaster124718503chaster_
chatter124416643chatter_
chatters134213933chatters
chaufer15347943chaufer_
chaufers16347283chaufers
chaunter1366383chaunter_
chaunters1455813chaunters
cheery144913153c_heery
chunter123911473chunter_
chunters133910893chunters
chute104316463chute__
chuted124611843chute_d
chutes114615763chute_s
chutney1533823chutney
cindery13429193cindery
cistern93310693cistern
citer74827323c_iter_
citers85022973c_iters
cittern9339133cittern
clatter94014973clatter_
clatters103313903clatters
clouter93511683clouter_
clouters10399793clouters
clovery15407403clovery
cluster94013323cluster_
clusters102912393clusters
clutchy17323893clutchy
clutter94211653clutter_
clutters103210343clutters
coaster94219033coaster_
coasters104317303coasters
coater84329553coater_
coaters93525773coaters
colter84625093colter_
colters93522433colters
cookery164210393cookery
coopery143910273coopery
cooter85128613cooter_
cooters94525713cooters
coppery16409393coppery
copter109822013copter_
copters113621273copters
coquetry2243553coquetry
coster84331293coster_
costers94128303costers
cotter84926673cotter_
cotters94323433cotters
coulter94115593coulter_
coulters103614303coulters
counter94220143counter_
counters103320183counters
country12388033country
courter94516463courter_
courters103015363courters
courtesy1364973courtesy
couteau938813couteau
couther123914623couther_
couture9310613couture
crafter124111333crafter_
crafters13419943crafters
crater85026633crater_
craters95021883craters
crudely1336273crudely
cruder95612383cruder_
cuatro838413cuat_ro
cuber95222533c_uber_
cubers105318343c_ubers
curer75030753c_urer_
curers84923183c_urers
curry105920343c_u_rry
curter85320073curter_
curtesy1265833curtesy
cutchery18265173c_utchery
cute66440453c_ute__
cutes79438313c_ute_s
cutest85820143c_utest
cuteys11569973c_uteys
cutler84718033c_utler_
cutlers94216993c_utlers
cutter84520993cutter_
cutters94218953cutters
cutty105417223c_ut_ty
cyclery1763493cyclery
dafter104813343dafter_
darter75320363darter_
darters84017603darters
datary10310243da_tary
dater65332313da_ter_
daters74827363da_ters
dauber94112013dauber_
daubers104610423daubers
daubry12445483dau_bry
daunter83811753daunter_
daunters9329843daunters
dauted84114933daute_d
dupery12378743_dupery
easter65027983easter_
easterly11246643easterly
eastern74412533eastern
easters75125683easters
eater54639843ea_ter_
eaters65535943ea_ters
factory15108343factory
faery116015483fa__ery
fakery16509263fa_kery
falter94519053falter_
falters103916473falters
faster94625773faster_
fatter94523213fatter_
flattery14338293flattery
fluter95316863fluter_
fluters103713673fluters
flutey125212523flute_y
fluttery14376143fluttery
gaiter73819503gaiter_
gaiters83516533gaiters
gallery11468743gallery
gantry103810113gant_ry
garter74420513garter_
garters84218223garters
gaster75027353gaster_
gasters85624283gasters
gater64533643ga_ter_
gaters74728633ga_ters
gauger84714853gauger_
gaugers94211703gaugers
gaunter82910713gaunter_
gauntry1154113gauntry
guttery11427753guttery
hafter124815883hafter_
hafters134614333hafters
halter94420883halter_
haltere103614703haltere
halters104619803halters
hater85034753ha_ter_
haters94930393ha_ters
hatter94724873hatter_
hatters104221523hatters
hauberk1633463hauberk
hauler95015123hauler_
haulers104012443haulers
haunter103111153haunter_
haunters11329533haunters
hautboy1553423hautboy
haute89521613haute__
hauteur1033893hauteur
hauteurs1133733hauteurs
jaggery19336903jaggery
japery18439143ja_pery
jaspery19405253jaspery
jittery17346443jittery
kaury12429763kau__ry
lactary1237843lactary
lantern7310013lantern
laster64830633laster_
lasters75627693lasters
lately93413843la_tely
later54843923la_ter_
lathery133911123lathery
latter65027893latter_
latterly1136063latterly
lauder73815013lauder_
lauders84012893lauders
laundry1133513laundry
littery103710493littery
lottery10389833lottery
martyry1533373martyry
master84831343master_
masterly13317653masterly
masters94628923masters
mater74438863ma_ter_
maters85032383ma_ters
matey107022663ma_te_y
matter84325343matter_
matters94421753matters
mauger93813483mauger_
mauler84416713mauler_
maulers94213303maulers
maumetry1543473maumetry
mutely113811653_mutely
muter74525543_muter_
mystery15436523mystery
napery11489813na_pery
natter64420743natter_
natters73718063natters
neuter63713793neuter_
neuters74212263neuters
nitery94412173_nitery
oater55433733oa_ter_
oaters65029783oa_ters
outcry1137993_outcry
outer55633303_outer_
outers64230163_outers
palter84423263palter_
palters94021683palters
paltry114910403palt_ry
pantry115014103pant_ry
papery134812743pa_pery
paster85734373paster_
pastern94415063pastern
pasters94531733pasters
pastry114913033past_ry
pater74740723pa_ter_
paters84935823pa_ters
patter84628263patter_
pattern93712053pattern
patters94825193patters
pauper103511943pauper_
paupers114311073paupers
pauser84415963pauser_
pausers94113223pausers
plastery13279703plastery
pottery123011073pottery
pouter83923983pouter_
pouters94221863pouters
prudery1335243prudery
psaltery13224733psaltery
quavery22225483quavery
query174212083_qu_ery
rafter94517583rafter_
rafters103715633rafters
ranter63826823ranter_
ranters73323643ranters
raster64731443raster_
rasters74629023rasters
rater54943283ra_ter_
raters63936573ra_ters
ratter64326313ratter_
ratters74422473ratters
router65025843router_
routers74822853routers
rudery10419033_rudery
salter64325083salter_
saltern74010653saltern
salters73622253salters
salutary1145113salutary
saluter73512453saluter_
saluters8319853saluters
santera7311303santera
santero7311133santero
saucer84314103saucer_
saucers93712133saucers
sauger74316253sauger_
saugers83914053saugers
saunter72913453saunter_
saunters82911743saunters
saury84317223sau__ry
saute55028083saute__
sauted74119603saute_d
sauteed8349613sauteed
sauterne846253sauterne
sautes63924913saute_s
scanter94215183scanter_
scatter93815173scatter_
scatters103612753scatters
scauper11379453scauper_
scaupers12378173scaupers
scouter93313323scouter_
scouters103411303scouters
souter64225923souter_
souters74422583souters
sputtery13366473sputtery
tannery10388663tannery
tarter64023563tarter_
taster64930573taster_
tasters74225643tasters
tater54138613ta_ter_
taters64932193ta_ters
tatter64024573tatter_
tatters74520483tatters
taunter73111453taunter_
taunters8259263taunters
tauted75317113taute_d
tauten64311893taute_n
tautens7317843tautens
tautest72612443tautest
tautly9499503taut_ly
tottery10388483tottery
touter63821033touter_
touters74018333touters
tuatera756363tuatera
uteri51012983__uteri
vaster94521023vaster_
vaulter10257713vaulter_
vaulters11206163vaulters
vaunter10309603vaunter_
vaunters11327743vaunters
wafery15398693wa_fery
wafter124114613wafter_
wafters134112813wafters
waggery15276903waggery
waiter94321253waiter_
waiters104218623waiters
wanter94423053wanter_
wanters104420093wanters
waster95228943waster_
wasters104026593wasters
wastry12388773wast_ry
water84733313wa_ter_
waters95030623wa_ters
watter93221983watter_
wavery154610053wa_very
wintery13399753wintery
yatter94116213yatter_
yatters103914623yatters
yauper11368543yauper_
yaupers12337663yaupers

Search took 9 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.1561145455.1
2DLD Change Limit1340275087.81317154.4
3Display Results5085080.1862731.2
 (SQL Overall)1786915088.15521911.8
 
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.