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

110 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
canzonas193538(None) 
canzona1836071canzona_
canzones1939151canzones
annonas738792_annonas
calzones1948762calzones
cannas84518402can__nas
cannons94412882cannon_s
canolas9313992can_olas
canons85522062can_on_s
cantinas102713772cantinas
cantonal1038902cantonal
cantons95221202canton_s
canyons124511592canyon_s
canzone1858812canzon_e
canzonet19410582canzonet
canzonets2044482canzonets
canzoni1836152canzon_i
anconal939423_anconal
ancones93116343_ancones
anginas8310953_anginas
angoras8811363_angoras
anions64123033_anion_s
annas55824883_an__nas
annona648873_annona_
anoas57226493_an_o_as
anyons94513503_anyon_s
azonal1568273_a_zonal
azons146518253_a_zon_s
bananas93312223ban_anas
bandanas11178573bandanas
bandoras1138743bandoras
cabanas112413033ca_banas
cabezones2243783cabezones
cabezons2144543cabezon_s
caeomas1138393ca_eomas
cajones163311333ca_jones
calzone1848623calzon_e
camions113916133camion_s
campongs15356123campongs
canastas1037693canastas
cancans11311873cancan_s
canchas143212403can_chas
candelas1139533candelas
candidas12338643candidas
candors104216763cando_rs
candours11408613candours
canellas10310563canellas
canines93724033can_ines
canna75919333can__na_
cannings113710333cannings
cannolis1037863cannolis
cannon84514443cannon__
cannonade12123943cannonade
cannonades13143813cannonades
cannoned11118133cannoned
cannonry1343283cannonry
cannulas1037583cannulas
canoers94318373can_oers
canoes84725883can_o_es
canola8313623can_ola_
canon74725303can_on__
canoness1039393can_oness
canonic11312933can_onic
canonise10511093can_onise
canonist10513533can_onist
canonry1235913can_onry
cansos84915383canso__s
cantalas104013523cantalas
cantatas103410083cantatas
cantina93417253cantina_
canton85722993canton__
cantoned111411523cantoned
cantors94620753canto_rs
cantos84826973canto__s
canulas9312853can_ulas
canvas113813333can__vas
canyon114512033canyon__
capons104119503ca_pon_s
carbons115418943carbon_s
carboras12311573carboras
cardons104519933cardon_s
carinas93622383ca_rinas
cariocas1239663cariocas
cartons94122473carton_s
cassenas10317483cassenas
cassinas103610633cassinas
catenas9313103ca_tenas
cations94524143cation_s
centones10313663centones
chansons1337473chanson_s
cinchonas1644003cinchonas
condones112817393condones
coronas93916903c_oronas
fanions103713073fanion_s
fanons96115213fan_on_s
fanzines2036913fanzines
lantanas838263lantanas
madronas11288493madronas
mananas93414733man_anas
mandolas1139133mandolas
maniocas12298463maniocas
mannas85019803man__nas
nandinas936573nandinas
nonas55126653__n_onas
pandoras11310053pandoras
ramonas9311093ra_monas
wanions104011373wanion_s
wantons103713013wanton_s
zananas16319563zan_anas
zanzas1487053zanz__as

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.1561145455.1
2DLD Change Limit1461621107.29620033.2
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.49823831.8
 
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.