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

206 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
canzone185881(None) 
calzone1848621calzone
canzona1836071canzona
canzones1939151canzones
canzonet19410581canzonet
canzoni1836151canzoni
ancone83916952_ancone
anyone94612732_anyone
cabezone2144432cabezone
calzones1948762calzones
canine83826702can_ine
cannon84514442cannon_
cannoned11118142cannoned
cannons94412882cannons
canoe75627252can_o_e
canon74725302can_on_
canons85522062can_ons
canton85722992canton_
cantoned111411522cantoned
cantons95221202cantons
canyon114512032canyon_
canyons124511592canyons
canzonas1935382canzonas
canzonets2044482canzonets
condone102616292condone
fanzine1937122fanzine
acetone9310793acetone
acnode938203acn_ode
agone65924553_a_gone
alone55732963_a_lone
ancon75718233_ancon_
ancones93116343_ancones
anemone9119453_anemone
anion55028813_anion_
anions64123033_anions
annona648873_annona
anode65021043_an_ode
anole55330383_an_ole
anon46134853_an_on_
anyon85615223_anyon_
anyons94513503_anyons
atone56527983_a_tone
axone125918473_a_xone
azine146721413_a_zine
azole145118033_a_zole
azon135725053_a_zon_
azons146518253_a_zons
azote144416343_a_zote
bandore10611633bandore
benzene1836343benzene
benzine1839343benzine
benzole1837133benzole
bizone1738603_bizone
cabezon2044663cabezon_
cabezones2243783cabezones
cabezons2144553cabezons
caboose1138273caboose
cajole154011183ca_jole
cajon144513903ca_jon_
cajones163311333ca_jones
calcine11315273calcine
callose9313663callose
camion103917193camion_
camions113916133camions
campong14318123campong
canape10913513can_ape
cancan10314103cancan_
cancans11311873cancans
candent10417363candent
candle94321483can_dle
candor94516423cando_r
candors104216763candors
candour104210243candour
cane66653123ca___ne
cangue91012443can_gue
canines93724033can_ines
caning94128623can_ing
canna75919333can__na
canned95022063can__ned
cannel84216403can__nel
canner84625983can__ner
cannie83819363can_nie
canning103620133canning
cannoli937263cannoli
cannonade12123953cannonade
cannoneer1143923cannoneer
cannonry1343293cannonry
cannot83616773canno_t
canny105817693can__ny
canoed94618963can_oed
canoer85121073can_oer
canoes84725883can_oes
canola8313623can_ola
canoness1039393can_oness
canonic11312933can_onic
canonise10511093can_onise
canonize1959833can_onize
canonry1235923can_onry
canoodle1144183canoodle
canopy1337723can_opy
canso75019403canso__
cansos84915383canso_s
canteen9411083canteen
cantina93417253cantina
canting104725903canting
cantle84522153can_tle
canto74931013canto__
cantonal1038903cantonal
cantor85621523canto_r
cantors94620753cantors
cantos84826973canto_s
canulae9311183canulae
canyoneer1443413canyoneer
capon95221873ca_pon_
capons104119503ca_pons
capote10315733ca_pote
caprine11314233caprine
capstone1237653capstone
carbine112918643carbine
carbon104919043carbon_
carbons115418943carbons
cardon94120853cardon_
cardons104519943cardons
cariole9818343cariole
carline93923613carline
carmine112918483carmine
carton84522663carton_
cartoned111312833cartoned
cartons94122473cartons
caseose939163caseose
caserne93710063caserne
cassene93111543cassene
cassine93817283cassine
cathode1338993cathode
cation83925503cation_
cations94524143cations
cauline92215603cauline
cayenne1244603cayenne
cenote83715843cen_ote
centones10313663centones
chalone12312103chalone
chanson1238043chanson_
chansons1337473chansons
chinbone1555163chinbone
chinone12510153chinone
cineole91010003cineole
clone75728163c__lone
colone85425003c_olone
compone136517193compone
condole102914953condole
condoned122612023condoned
condoner112913413condoner
condones112817393condones
cone67256963c___one
confine12315583confine
coniine9316803coniine
conine84528553con_ine
connote9311613connote
console92715983console
convene123314323convene
convoke16207173convoke
cornpone1246933cornpone
crannoge1144263crannoge
crone75231333c__rone
cyanine122911513cyan_ine
cyclone1437243cyclone
dapsone1038463dapsone
downzone21134273downzone
evzone1894683_evzone
fanion94514323fanion_
fanions103713073fanions
fanon84619013fan_on_
fanons96115213fan_ons
fanzines2036913fanzines
halazone2046103halazone
hambone1439313hambone
intone61115433_intone
ionone6313443ion_one
jawbone19134443jawbone
lactone9311413lactone
ladrone83611873ladrone
lanose6313593lan_ose
madrone102812663madrone
mangonel1185763mangonel
manhole12311343manhole
mannose939243mannose
manrope1138033manrope
none45743173__n_one
ozone14310613__ozone
padrone102512073padrone
pandore10411853pandore
pangene102711963pangene
panne76623653pan__ne
pinbone1138183pinbone
rezone153814783_rezone
subzone1846993subzone
undone7914253_undone
unzoned172310653_unzoned
wanion93213063wanion_
wanions104011373wanions
wanton94413813wanton_
wantoned12117223wantoned
wantoner1187563wantoner
wantons103713013wantons
xanthone1847113xanthone
zone135231083___zone

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.403443402.0
2DLD Change Limit1340272066.78319759.3
3Display Results2062060.0762710.5
 (SQL Overall)1786912067.26224606.3
 
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.