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

216 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
calzones194876(None) 
calzone1848621calzone_
canzones1939151canzones
cabezones2243782cabezones
cajones163311332ca_jones
calcines12314752calcines
calloses10313392calloses
canzonas1935382canzonas
canzone1858812canzone_
canzonet19410582canzonet
canzonets2044482canzonets
chalones13312172chal_ones
clones84526562c_l_ones
colones96124432col_ones
halazones2145992halazones
abalones1038753abal_ones
acetones10310033acetones
agones75719863_a_gones
alcoves1297873_alcoves
aldoses8311203_aldoses
alines65735223_al_ines
alkanes113812933_alkanes
alkenes114212753_alkenes
alkines114415733_alkines
alkynes14336463_alkynes
allonges937313_allonges
almonds10127953_almonds
almoner949383_almoner
almoners1068133_almoners
aloes54933673_al_o_es
alone55732963_al_one_
alpines94016193_alpines
ambones11312683_ambones
ancones93116343_ancones
atones65225773_a_tones
axones134614513_a_xones
azines155517073_a_zines
azlons154110423_azlon_s
azoles154614613_a_zoles
azons146518253_a_zon_s
azotes154312223_a_zotes
balconies1347743balconies
ballonet10314503ballonet
ballonets1146723ballonets
ballonnes1145323ballonnes
ballons93916963ballon_s
baloney1237483bal_oney
baloneys1334663bal_oneys
bizones1837823_bizones
blazoned2044313blazoned
blazoner1944133blazoner
blazoners2043863blazoners
blazons1836163blazon_s
cabezone2144433cabezone_
cabezons2144553cabezon_s
cabooses1237863cabooses
cajoles163712103ca_joles
calamines13312223calamines
calashes13310533calashes
calcanea1276273calcanea
calcanei1265263calcanei
calcaneus1344163calcaneus
calces104420053cal__ces
calcine11315273calcine_
calcined1338743calcined
calcites12313003calcites
caldrons1138063caldron_s
caleches15269933caleches
calends1039523cal_ends
calibres1237103calibres
calices114321693cal_ices
caliches153812263caliches
calicles123811433calicles
calicoes123911593calicoes
calipees1247413calipees
calkings15289223calkings
calkins133814873calkin_s
callans94518473callan_s
callants104112143callants
callees94117783cal_lees
callings113613833callings
calliopes1346143calliopes
callose9313663callose_
callous93516603callo_us
callouses1147683callouses
callower13159073callower
callowest1445823callowest
callowness1543013callowness
calluses1039323calluses
calmness1236643cal_mness
calomel1138073cal_omel
calomels1236133cal_omels
calories102919553calories
calos74431903cal_o__s
calottes10610083calottes
caloyer1238143cal_oyer
caloyers1337343cal_oyers
calques182710193cal_ques
calumnies1346043calumnies
calves115119283cal__ves
calxes154113033cal__xes
calyces14428803cal_yces
calycles15295693calycles
calyxes19426233cal_yxes
camions113916133camion_s
campongs15356123campongs
canes75350373ca___nes
canines93724033ca_nines
cannoned11118143cannoned
cannons94412883cannon_s
canoes84725883ca_no_es
canoness1039393ca_noness
canons85522063ca_non_s
cantoned111411523cantoned
cantons95221203canton_s
canyons124511593canyon_s
canzona1836073canzon_a
canzoni1836153canzon_i
capons104119503ca_pon_s
capotes11314643ca_potes
capstones1347373capstones
carbines123617533carbines
carbons115418943carbon_s
cardons104519933cardon_s
cargoes104415223cargo_es
carioles10817073carioles
carlines103521643carlines
carmines123617863carmines
cartoned111312833cartoned
cartons94122473carton_s
caseoses1039293caseoses
casernes103810753casernes
cassenes103611293cassenes
cassines103116613cassines
cathodes1439393cathodes
cations94524143cation_s
cayennes1345013cayennes
centones10313663centones
chalone12312103chal_one_
chinones13510473chinones
cladodes1245323cladodes
claroes93113733claro_es
claxons1635803claxon_s
cleomes1138813c_leomes
clines84926043c_l_ines
clone75728163c_l_one_
cloned94518803c_l_oned
cloner84418093c_l_oner
cloners94514823c_l_oners
clonks125013473c_l_onks
clons75228133c_l_on_s
clonus85212413c_l_onus
closes85425593c_l_oses
cloves114918823c_l_oves
clozes174915563c_l_ozes
coalboxes2043683coalboxes
coalholes1445373coalholes
cojones163512103c_ojones
colognes11310603colognes
colone85425003col_one_
colonel94213283col_onel
colonels104210453col_onels
colonies103620013col_onies
colons86028683col_on_s
colonus94413443col_onus
condones112817393condones
cones76457423c___ones
crones84729243c__rones
cyclones1537483cyclones
daemones11209163daemones
daimones11208803daimones
daltons8310403dalton_s
dapsones1138383dapsones
evzones1964523_evzones
falconer1346033falconer
falconers1445323falconers
falconet13410353falconet
falconets1444813falconets
falcons1239123falcon_s
fanzines2036913fanzines
flavones1435833flavones
gallons83015953gallon_s
galores82614323gal_ores
halazone2046093halazone_
halftones1545213halftones
halloes104021523hallo_es
haloes94623863hal_o_es
halons95720713hal_on_s
hambones1539673hambones
jawbones20134853jawbones
kalongs1255443kal_ongs
lactones10311223lactones
ladrones92710973ladrones
leones64417723__leones
madrones112912283madrones
malines93625603mal_ines
maltoses1039853maltoses
naloxones1642653naloxones
ozones1539393__ozones
padrones112711043padrones
rezones163213943_rezones
salines74029413sal_ines
salmons93713263salmon_s
salons63823693sal_on_s
saloons74415323saloon_s
saltines82917793saltines
salvoes102811313salvo_es
sawbones13126643sawbones
subzones1947223subzones
sulfones1147683sulfones
tailbones1155263tailbones
talions7314113talion_s
taloned8310223tal_oned
talons64019443tal_on_s
valines104520213val_ines
zones145528043___zones

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 Filter1786911461620.453394461.4
2DLD Change Limit1461622166.51622431.2
3Display Results2162160.0932322.6
 (SQL Overall)1786912167.06225303.2
 
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.