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

153 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
cauteries1161539(None) 
catteries11815521catteries
causeries11510641causeries
cauterizes2197991cauterizes
arteries8321482_arteries
batteries11615112batteries
canneries11313082canneries
causerie1078272causerie_
cauterize2088312cauterize
cauterized2286312cauterized
coteries10422702c_oteries
cutleries1179212c_utleries
dauberies1248032dauberies
eateries8324312ea_teries
gauderies1147742gauderies
masteries111018492masteries
sauternes947022sauternes
wasteries121115342wasteries
actuaries1147573actuaries
adulteries1145623adulteries
aeries64737783_a__eries
amberies122514683_amberies
aperies9423203_a_peries
asterias8317013_asterias
auberges1146673_auberges
auguries947933_auguries
autarkies1344773_autarkies
bacterias1349283bacterias
bacterins13410643bacterins
bacterizes2347973bacterizes
bakeries14312193ba_keries
batterie10711533batterie_
booteries11312773booteries
butleries11710073_butleries
butteries11711763butteries
cachexies2364163cachexies
cafeterias1553773cafeterias
cajoleries1944763cajoleries
calories102919563ca_lories
calvaries1449803calvaries
canaries10318943ca_naries
canonries1148413canonries
cantered113415983canter_ed
cantering122417373cantering
canters94827733canter__s
cantrips12318933cant_rips
captures1239443captur_es
caries85147623ca___ries
carries94328013ca__rries
cartelise1148113cartelise
cartelises1247683cartelises
cartelizes2147633cartelizes
carters95327253carter__s
casefies1339213ca_sefies
casernes103810753ca_sernes
casters94729903caster__s
catbrier1236173ca_tbrier
catbriers1344143ca_tbriers
categories1346073ca_tegories
catenaries1248663ca_tenaries
caterans10313223ca_terans
catered103117773ca_ter_ed
caterer92815943ca_ter_er
caterers102814403ca_terers
cateress102311613ca_teress
catering112019903ca_tering
caters85336503ca_ter__s
catties94023053ca_t_ties
caudexes1843843caude_xes
causers94014793causer__s
cauterant1148533cauterant
cauterants1244713cauterants
cautery12349593cauter__y
cavalries1446363cavalries
celeries10316313c_eleries
cemeteries1447383cemeteries
centuries11311333centuries
chanceries1747653chanceries
chantries14310293chant_ries
charcuteries1993153charcuteries
congeries12316403congeries
cookeries151210633cookeries
cooperies131113313cooperies
coquetries2146023coquetries
coterie9417403c_oterie_
countries11313613countries
courtesies1246453courtesies
couters93827303couter__s
coutures10311993coutur_es
couturier1145423couturier
couturiers1243853couturiers
curies84934023c_u__ries
curries93723163c_u_rries
curtesies1147523curtesies
cutcheries1745083c_utcheries
cutesie937963c_utesie_
cutesier1045623c_utesier
cutesiest1146103c_utesiest
cuties84927363c_ut__ies
cutties93118843c_ut_ties
cycleries1647033cycleries
dataries9314033da_taries
daubries1136743dau_bries
dauties83315763daut__ies
deuterides1245253deuterides
duperies11312813_duperies
easterlies1046713easterlies
factories14810113factories
faeries104118993fa__eries
fakeries1559833fa_keries
fauteuils1242073fauteuils
flatteries1347423flatteries
galleries10311713galleries
gantries91413793gant_ries
gaucheries1644543gaucheries
gauntries1046043gauntries
halteres113414603halter_es
hatterias1258743hatterias
jaggeries18136973jaggeries
japeries17311463ja_peries
kauries113613193kau__ries
laterites9715063la_terites
laterizes18513023la_terizes
laundries1045563laundries
lotteries9311073lotteries
martyries1446563martyries
materiel10311253ma_teriel
materiels1147833ma_teriels
maumetries1446023maumetries
mysteries141211193mysteries
naperies10313903na_peries
niteries8318383_niteries
outcries10313573_outcries
pantries101817393pant_ries
papeteries1446553papeteries
parterres1148063parterres
pastries101517423past_ries
pauperizes2344773pauperizes
potteries11313593potteries
pruderies1247873pruderies
psalteries1276563psalteries
queries16315873_qu_eries
ruderies9311333_ruderies
santerias9311843santerias
sauries72821623sau__ries
sauterne846253sauterne_
sautoires944803sautoires
tanneries9310423tanneries
waggeries14127463waggeries
wasterie111211583wasterie_
wastries111212883wast_ries
waterier11312083wa_terier
wateriest12312233wa_teriest

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411536.97021325.8
3Display Results1531530.0762013.2
 (SQL Overall)1786911537.46623934.0
 
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.