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

202 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
canzones193915(None) 
calzones1948761calzones
canzonas1935381canzonas
canzone1858811canzone_
canzonet19410581canzonet
canzonets2044481canzonets
ancones93116342_ancones
cabezones2243782cabezones
cajones163311332ca_jones
calzone1848622calzone_
canines93724032can_ines
cannoned11118132cannoned
cannons94412882cannon_s
canoes84725882can_o_es
canoness1039392can_oness
canons85522062can_on_s
cantoned111411522cantoned
cantons95221202canton_s
canyons124511592canyon_s
canzona1836072canzon_a
canzoni1836152canzon_i
centones10313662centones
condones112817392condones
fanzines2036912fanzines
acetones10310033acetones
acnodes1037823acn_odes
agones75719863_a_gones
ambones11312683_ambones
ancone83916953_ancone_
anemones10249473_anemones
anions64123033_anion_s
annonas738793_annonas
anodes74418753_an_odes
anoles64827423_an_oles
anyone94612733_anyone_
anyons94513503_anyon_s
atones65225773_a_tones
axones134614513_a_xones
azines155517073_a_zines
azoles154614613_a_zoles
azons146518253_a_zon_s
azotes154312223_a_zotes
bandores11311603bandores
banjoes16317313banjo_es
benzenes1946853benzenes
benzines1938213benzines
benzoles1936993benzoles
bizones1837823_bizones
cabezone2144433cabezone_
cabezons2144543cabezon_s
cabooses1237863cabooses
cajoles163712103ca_joles
calcines12314753calcines
calloses10313383calloses
camions113916133camion_s
campongs15356123campongs
canapes111213083can_apes
canaries10318943canaries
cancans11311873cancan_s
candies104125613can_dies
candles104422343can_dles
candors104216763cando_rs
candours11408613candours
canes75350373ca___nes
cangues10611823can_gues
canine83826703can_ine_
canities101519243canities
cannas84518403can__nas
canned95022063can__ned
cannel84216403can__nel
cannels93413363can__nels
canner84625983can__ner
canners93822663can__ners
canniness1138643canniness
cannings113710333cannings
cannolis1037863cannolis
cannon84514443cannon__
cannonades13143813cannonades
cannoneer1143903cannoneer
cannoneers1243313cannoneers
cannonries1244093cannonries
cannonry1343283cannonry
canoe75627253can_o_e_
canoed94618953can_o_ed
canoer85121073can_o_er
canoers94318373can_oers
canolas9313993can_olas
canon74725303can_on__
canonic11312933can_onic
canonise10511093can_onise
canonises11410803can_onises
canonist10513533can_onist
canonizes2049593can_onizes
canonries1148413can_onries
canonry1235913can_onry
canoodles1243993canoodles
canopies12311853canopies
cansos84915383canso__s
canteens1038573canteens
cantinas102713773cantinas
cantles94721413can_tles
canton85722993canton__
cantonal1038903cantonal
cantors94620753canto_rs
cantos84826973canto__s
canvases13349513canvases
canyon114512033canyon__
canyoneer1443403canyoneer
canyoneers1542923canyoneers
capons104119503ca_pon_s
capotes11314643ca_potes
capstones1347373capstones
carbines123617533carbines
carbons115418943carbon_s
cardons104519933cardon_s
cargoes104415223cargo_es
carioles10817063carioles
carlines103521643carlines
carmines123617863carmines
cartoned111312833cartoned
cartons94122473carton_s
caseoses1039293caseoses
casernes103810753casernes
cassenes103611293cassenes
cassines103116613cassines
cathodes1439373cathodes
cations94524143cation_s
cayennes1345013cayennes
cenotes92814543cen_otes
chalones13312173chalones
chansons1337473chanson_s
chinbones1655033chinbones
chinones13510473chinones
cineoles10109403cineoles
clones84526563c__lones
cojones163512103c_ojones
colones96124433c_olones
condoes104319203condo_es
condoles113015803condoles
condone102616293condone_
condoned122612023condoned
condoner112913393condoner
condoners122811493condoners
condores113315633condores
cones76457423c___ones
confines13315653confines
congoes103617303congo_es
coniines10415363coniines
conines93827793con_ines
conioses10313313conioses
connotes10311453connotes
consoles103216153consoles
convenes132916913convenes
convokes17247703convokes
cornpones1347103cornpones
crannoges1244243crannoges
crones84729243c__rones
cyanines132710543cyan_ines
cyanoses1337423cyan_oses
cyclones1537483cyclones
daemones11209163daemones
daimones11208803daimones
dapsones1138383dapsones
downzones22123843downzones
evzones1964523_evzones
fanions103713073fanion_s
fanons96115213fan_on_s
fanzine1937123fanzine_
ginzoes1735433ginzo_es
halazones2145983halazones
hambones1539673hambones
intones7816533_intones
ionones7313883ion_ones
jawbones20134853jawbones
lactones10311223lactones
ladrones92710973ladrones
madrones112912283madrones
mangoes104316133mango_es
mangonel1185753mangonel
mangonels1294363mangonels
manholes13311183manholes
mannoses1039083mannoses
manropes1237913manropes
nones55639133__n_ones
ozones1539393__ozones
padrones112711043padrones
pandores11312453pandores
pangenes112612823pangenes
pannes85522853pan__nes
pinbones1238133pinbones
pinones94717063pin_ones
rezones163213943_rezones
sawbones13126643sawbones
subzones1947213subzones
unzoned172310653_unzoned
wanions104011373wanion_s
wantoned12117223wantoned
wantoner1187553wantoner
wantoners12116663wantoners
wantons103713013wanton_s
xanthones1957023xanthones
zones145528043___zones

Search took 9 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 Limit1461622027.86018595.7
3Display Results2022020.0932172.0
 (SQL Overall)1786912028.10922036.1
 
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.