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

150 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
chansons133747(None) 
chanson1238041chanson_
cannons94412882c_annons
canons85522062c_an_ons
cansos84915382c_anso_s
cantons95221202c_antons
canyons124511592c_anyons
chanfrons1744622chanfrons
chantors133710262chantors
classons1037702classons
hansoms12238522_hansoms
abandons1145353abandons
anions64123033__anions
anyons94513503__anyons
arsons63917213__arsons
caissons1036283caissons
camions113916133c_amions
cancans11311873c_ancans
candors104216763c_andors
cannon84514443c_annon_
canoes84725883c_an_oes
canon74725303c_an_on_
canso75019403c_anso__
canton85722993c_anton_
cantors94620753c_antors
cantos84826973c_anto_s
canyon114512033c_anyon_
canzona1836073c_anzona
canzonas1935383c_anzonas
canzone1858813c_anzone
canzones1939153c_anzones
canzoni1836153c_anzoni
capons104119503c_a_pons
carbons115418943c_arbons
cardons104519943c_ardons
cartons94122473c_artons
cations94524143c_ations
censors93611843c_ensors
chadors1338753cha_dors
chaebols1544723chaebols
chagrins1437073chagrins
chains114819703cha__ins
chainsaws1742263chainsaws
chaises124317493chais_es
chaldrons1545493chaldrons
chalone12312103cha_lone
chalones13312173cha_lones
chamfrons1944383chamfrons
chamisos15307423chamiso_s
chamois143512193cha_mois
champions18875783champions
chancels15439093chancels
chancers154313493chancers
chances145218093chan_ces
chancing162810283chancing
chancres15429363chancres
chancrous1644873chancrous
chanfron1644803chanfron_
changers144313203changers
changes134517583chan_ges
changing153211513changing
changs125215373chan__gs
channels13388503channels
chanoyu1544483chan_oyu
chanoyus1643923chanoyus
chanters134016743chanters
chanteys16387493chanteys
chanties132615803chanties
chanting143413533chanting
chantor123710313chanto_r
chants115020393chan__ts
chaos105622863cha__o_s
chaoses124715123chaos_es
chaperons1646893chaperons
chariots1339393chariots
charpoys1834533charpoys
charros124312153charro_s
chasers123714923cha_sers
chases115128233cha_s_es
chasing133715893cha_sing
chasings14318253cha_sings
chasms135513143cha_s_ms
chasses124017503cha_sses
chassis123910663cha_ssis
chastens13429183chastens
chausses1345963chausses
chazans21268123cha_zans
chazzans21234503chazzans
chazzens21253943chazzens
chevrons1665463chevrons
chiffons1943693chiffons
chignons1444713chignons
chinbone1555163chinbone
chinbones1655033chinbones
chinone12510163chin_one
chinones13510483chin_ones
chinooks1774783chinooks
chinos115018693chin_o_s
chitons122611913ch_itons
chorions13310663chorions
chrismons1644003chrismons
chrisoms1566093chrisoms
chronons1347353chronons
clangors11417003clangors
clarions10310493clarions
classon937693classon_
claxons1635803cla_xons
coarsens10348123coarsens
consols92914073c_onsols
crampons1436643crampons
crankous1435973crankous
crannogs1143783crannogs
cratons94316033cra_tons
crayons12439233cra_yons
crimsons1245633crimsons
cyanins122910013cyan_ins
cyanoses1337423cyanoses
cyanosis1346273cyanosis
damsons1038013_damsons
fanions103713073_fanions
fanons96115213_fan_ons
grandsons1145123grandsons
hadrons113314303_hadrons
hagdons1258523_hagdons
halons95720713_ha_lons
hansas94616043_hans_as
hansels104011663_hansels
hanses95022633_hans_es
hansom11219153_hanso_m
hausens1077633_hausens
hysons1237633_h_ysons
johnsons1842383johnsons
khamsins1743393khamsins
liaisons844293liaisons
mansions1069793_mansions
masons83916513_ma_sons
parsons93516873_parsons
phaetons1345853phaetons
phantoms1545973phantoms
phonons123310253phon_ons
ramsons939563_ramsons
ransoms92410163_ransoms
reasons72514943rea_sons
scansions1145323scansions
seasons72614233sea_sons
sponsons1045813sponsons
transoms1048933transoms
wanions104011373_wanions
wantons103713013_wantons
weasons102310583wea_sons

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.406440125.6
2DLD Change Limit1461621507.69019006.8
3Display Results1501500.0602500.0
 (SQL Overall)1786911508.15621909.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.