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

351 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
caesars941072(None) 
caesar8410931caesar_
caesarism1345932caesarism
caestus947772caestus
caesura956222caesura
caesuras1055722caesuras
calcars11312652calcars
calesas9411822calesa_s
casas75327842ca_sa_s
causals91411182causals
causers94014782causers
caviars1238622caviars
cedars93312832c_edars
clears84116562cle_ars
paesans93312692paesans
sansars73313912sansars
sarsars73512142sarsars
acetals93411353acetals
afars85716513_a_fars
agars66120643_a_gars
alegars838933alegars
altars64518153_altars
anears63717183_anears
assais6711963_assais
assays977903_assays
attars64515313_attars
balsams11579013balsams
balsas86417523balsa_s
baresark1443883baresark
baresarks1543433baresarks
bazaars18275883bazaars
bazars174613113ba_zars
bears75739043_be_ars
blears85116453ble_ars
bursars94510893bursars
cabals104020153ca_bals
cabers105023903ca_bers
cabestro1243673cabestro
cabestros1343853cabestros
cablers114416713cablers
cacaos104616183ca_caos
cacas95627983ca_ca_s
cadgers114711993cadgers
caeca93915133caeca__
caecal103713733caeca_l
caeomas1138393caeomas
caesarean1143263caesarean
caesareans1252343caesareans
caesarian1147053caesarian
caesarians1244943caesarians
caesarisms1444903caesarisms
caesium1158833caesium
caesiums1245533caesiums
caesurae1055113caesurae
caesural1055383caesural
caesuric1244213caesuric
caftans12179443caftans
cagers95624183ca_gers
cahiers123510673cahiers
caimans113811783caimans
calamars1238133calamars
calcar10312753calcar_
calcspars1542633calcspars
calendars1244523calendars
calesa8412473calesa__
calkers134414693calkers
callans94518473callans
callas84526753calla_s
callers94221963callers
calpacs133110343calpacs
calvary1537183calvary
camas96333523ca_ma_s
camases114216343camases
camass104114183ca_mass
cambers134017433cambers
cameras11313343camera_s
camisas113411923camisa_s
campers134220283campers
canals84421663ca_nals
canard9314763ca_nard
canards10311203ca_nards
canary11314693ca_nary
cancans11311873cancans
cancers114018583cancers
candors104216763candors
caners84629193ca_ners
caneware1347803caneware
canewares1447363canewares
cankers134418753cankers
cannas84518403canna_s
canners93822663canners
canoers94318373canoers
cansos84915383cans_os
cantals93919573cantals
canters94827723canters
cantors94620753cantors
canvas113813333canva_s
canvass12376873canvass
capelans1238013capelans
caperers122611723caperers
capers105428133ca_pers
capias10318353capia_s
cappers134419403cappers
capsids1239333capsids
capstans1257243capstans
captans111612053captans
captors113914983captors
carats85929023ca_rats
carbarn1139453carbarn
carbarns1238563carbarns
carcass11310513carcass
carders104820353carders
careers95218783careers
carers85133953ca_rers
caress85720263cares__s
caressers1137433caressers
caresses10314063caresses
carfare12310073carfare
carfares13310323carfares
carpals113414623carpals
carpers114521253carpers
carrs75730853ca__rrs
cars67364763c___ars
carses85233653cars_es
carters95327243carters
carvers124817533carvers
casa65630863ca_sa__
casaba1079263ca_saba
casabas1139983ca_sabas
casava1157873ca_sava
casavas1237813ca_savas
casbahs1436463casbahs
cascara1138313cascara
cascaras1237693cascaras
casease939323casease
caseases10410473caseases
caseate9314783caseate
caseates10313703caseates
caseins93115053caseins
caseous9312513caseous
casern84713313ca_sern
caserns94711213caserns
cases75048383ca_s_es
cashaws15398573cashaws
cashes114729883ca_shes
casks115720063ca_s_ks
cassaba1145663cassaba
cassabas1245733cassabas
cassata938143cassata
cassatas1036673cassatas
cassava1255003cassava
cassavas1344803cassavas
cassias93514343cassias
cassis84818853ca_ssis
casters94729893casters
castes85631863ca_stes
castors94919433castors
casts77237793ca_s_ts
casuals91410523casuals
casus76419253ca_s_us
catenary1346583catenary
catenas9313103catena_s
caterans10313203caterans
caterers102814393caterers
caters85336493ca_ters
catnaps1197033catnaps
catspaws1543163catspaws
catsups1135333catsups
causal81413203causa_l
causer84117783causer_
causes88026473caus_es
causeys12387223causeys
caveats1239803caveats
cavers115026833ca_vers
caviar11310163caviar_
caviare1238373caviare
caviares1337993caviares
caymans14349513caymans
ceases84427073ceas_es
cedar84014323c_edar_
cedarn9408443c_edarn
cedary12419603c_edary
ceders93817673c_eders
cellars93713693cellars
censers94313903censers
censors93611833censors
cess65326053c_es__s
cesses84221363c_esses
cestas85018543c_estas
cestos84718093c_estos
cestus84412913c_estus
cesura838763c_esura
cesuras958683c_esuras
chadars1338273chadars
chars105936633c__hars
chasers123714893chasers
cheaps134613683che_aps
cheats114519543che_ats
cheddars15234373cheddars
cheders134512393cheders
cheers114518913che_ers
chelas113817203chela_s
chess105016923ches__s
chesses124112633chesses
chests114916263ches_ts
chetahs15347073chetahs
chewers154111133chewers
chimars144010573chimars
chresard1444053chresard
chresards1543253chresards
chukars1634273chukars
cigars9910713c_igars
classers104111833classers
cleans85817053cle_ans
clear76219053cle_ar_
cleats84919313cle_ats
closers94415313closers
coaevals1344553coaevals
coevals1237873coevals
collars93816573collars
corsacs1139013corsacs
corsairs1046863corsairs
costars94217993costars
cottars94412233cottars
cougars1038423cougars
creaks124315963cre_aks
creams104715253cre_ams
creasers103612813creasers
creases94020963creases
cresols939643cresols
cress75022833cres__s
cresses94219813cresses
crests85218703cres_ts
cresyls1234753cresyls
cuestas957933cuestas
cursers94317153cursers
cursors93910023cursors
cussers94213393cussers
cyeses11510123cyes_es
cyesis1148573cyes_is
cymars13599143c_ymars
czars164812913c__zars
damars93814993da_mars
dammars12308193dammars
darbars10510093darbars
daystars1243903daystars
dears65736883_de_ars
debars94218043_debars
denars74621433_denars
dewars105117073_dewars
drears74614253dre_ars
ears46356593__e_ars
escars83913133__escars
eskars10357593__eskars
eyebars1245333eyebars
faenas94412763faena_s
fears84829393_fe_ars
feuars938653_feuars
gassers84714633gassers
gaydars1235803gaydars
gazars164811553ga_zars
gears64628693_ge_ars
haars85620473ha__ars
hangars114313483hangars
hansas94616043hansa_s
hawsers13409483hawsers
hears86737373_he_ars
hussars10326973hussars
jaegers15307103jaegers
jaguars1535223jaguars
kabars124513953ka_bars
kaisers11369273kaisers
kantars11310033kantars
kebars124112493_kebars
lahars94013163la_hars
lapsers93911053lapsers
lascars979013lascars
lasers64925703la_sers
lazars153812393la_zars
lears55938733_le_ars
leasers74717843leasers
maars74621633ma__ars
maenads1037373maenads
maestri945473maestri
maestro945723maestro
maestros1046163maestros
makars124612633ma_kars
malars85020683ma_lars
mansard1049313mansard
mansards1148013mansards
masas75630413ma_sa_s
masers84623453ma_sers
massas85116463massa_s
matsahs1236563matsahs
mesas76823203_mesa_s
nasals63312463na_sals
navars92810573na_vars
naysays1344123naysays
nears55529423_ne_ars
paeans85118263pae_ans
paesan85114093paesa_n
paesani9348683paesani
paesano9338793paesano
paesanos10296703paesanos
paisans93614753paisans
paisas84317493paisa_s
parsers94118153parsers
passers94717753passers
pausers94113223pausers
pears75138613_pe_ars
pulsars9358913pulsars
quasars1646903quasars
radars71314663ra_dars
raisers73617393raisers
rasers64526783ra_sers
rears54739653_re_ars
rebars84019823_rebars
resaws93713513_resaws
resays93714153_resays
saggars93610683saggars
salsas65316133salsa_s
sambars115113843sambars
samsara936913samsara
samsaras1045873samsaras
sangars83116253sangars
sansar63613393sansar_
sardars83112903sardars
sarsar63011843sarsar_
scalars93711903sca_lars
sears54744913_se_ars
seesaws1034703seesaws
sewars94018623_sewars
shears93820903she_ars
smears84714433sme_ars
spears84019473spe_ars
swears94114073swe_ars
talars66021683ta_lars
tarsals72512603tarsals
tartars73313403tartars
tatars64619793ta_tars
tears55436463_te_ars
teasers75317243teasers
thenars10248503thenars
tsars56717103__tsars
tussars7359243tussars
vassals1057953vassals
velars93913723_velars
warsaws1335763warsaws
wears86030303_we_ars
years84527673_ye_ars
zaffars22325233zaffars

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.1401276364.3
2DLD Change Limit1340273517.15618729.3
3Display Results3513510.1232853.7
 (SQL Overall)1786913517.41924085.6
 
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.