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

136 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
canzona183607(None) 
canzonas1935381canzonas
canzone1858811canzone
canzoni1836151canzoni
annona648872_annona
calzone1848622calzone
canna75919332can__na
cannon84514442cannon_
cannons94412882cannons
canola8313622can_ola
canon74725302can_on_
canons85522062can_ons
cantina93417252cantina
canton85722992canton_
cantonal1038902cantonal
cantons95221202cantons
canyon114512032canyon_
canyons124511592canyons
canzones1939152canzones
canzonet19410582canzonet
ancon75718233_ancon_
anconal939423_anconal
ancone83916953_ancone
angina7413133_angina
angora71111573_angora
anion55028813_anion_
anions64123033_anions
anna45529013_an__na
annonas738793_annonas
anoa45634473_an_o_a
anon46134853_an_on_
anyon85615223_anyon_
anyone94612733_anyone
anyons94513503_anyons
azon135725053_a_zon_
azonal1568273_a_zonal
azons146518253_a_zons
banana83213413ban_ana
bandana10179463bandana
bandora1038813bandora
cabana103913563ca_bana
cabezon2044663cabezon_
cabezone2144433cabezone
cabezons2144543cabezons
caeoma1039033ca_eoma
cajon144513903ca_jon_
calzones1948763calzones
camion103917193camion_
camions113916133camions
campong14318123campong
canasta938363canasta
cancan10314103cancan_
cancans11311873cancans
cancha134411613can_cha
candela1089743candela
candent10417363candent
candida114110253candida
candor94516423cando_r
candors104216763candors
candour104210233candour
canella9310793canella
canine83826703can_ine
caning94128623can_ing
cannas84518403can__nas
canning103620133canning
cannoli937263cannoli
cannonade12123943cannonade
cannoned11118133cannoned
cannonry1343283cannonry
cannot83616773canno_t
cannula937433cannula
canny105817693can__ny
canoe75627253can_o_e
canoed94618953can_oed
canoer85121073can_oer
canoes84725883can_oes
canolas9313993can_olas
canonic11312933can_onic
canonry1235913can_onry
canopy1337723can_opy
canso75019403canso__
cansos84915383canso_s
cantala94114673cantala
cantata93811813cantata
cantinas102713773cantinas
canting104725903canting
canto74931013canto__
cantoned111411523cantoned
cantor85621523canto_r
cantors94620753cantors
cantos84826973canto_s
canula8312963can_ula
canzonets2044483canzonets
capon95221873ca_pon_
capons104119503ca_pons
carbon104919043carbon_
carbons115418943carbons
carbora11310703carbora
cardon94120853cardon_
cardons104519933cardons
carina84325323ca_rina
carioca1139683carioca
carton84522663carton_
cartons94122473cartons
cassena9287843cassena
cassina94113163cassina
catena8312473ca_tena
cation83925503cation_
cations94524143cations
chanson1238043chanson_
chansons1337473chansons
cinchona1554403cinchona
condone102616293condone
corona83817403c_orona
fanion94514323fanion_
fanions103713073fanions
fanon84619013fan_on_
fanons96115213fan_ons
fanzine1937123fanzine
lantana739603lantana
madrona10288703madrona
manana84816073man_ana
mandola1039023mandola
manioca11358943manioca
manna75522533man__na
nandina838913nandina
nona46929063__n_ona
pandora1039543pandora
ramona8412413ra_mona
wanion93213063wanion_
wanions104011373wanions
wanton94413813wanton_
wantons103713013wantons
zanana153810363zan_ana
zanza1378703zanz__a
zona136321963___zona

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.1561145455.1
2DLD Change Limit1340271367.15618729.3
3Display Results1361360.0433162.8
 (SQL Overall)1786911367.35524295.2
 
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.