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

191 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
chanson123804(None) 
chansons1337471chansons
cannon84514442c_annon
canon74725302c_an_on
canso75019402c_anso_
cansos84915382c_ansos
canton85722992c_anton
canyon114512032c_anyon
chanfron1644802chanfron
chantor123710312chantor
classon937692classon
hansom11219152_hansom
abandon1045463abandon
ancon75718233__ancon
anion55028813__anion
anon46134853__an_on
anyon85615223__anyon
arson55118833__arson
caisson936593caisson
cajon144513903c_a_jon
camion103917193c_amion
cancan10314103c_ancan
candor94516423c_andor
cannons94412883c_annons
cannot83616773c_annot
canoe75627253c_an_oe
canons85522063c_an_ons
cans65050853c_ans__
canst74932213c_ans_t
canto74931013c_anto_
cantons95221203c_antons
cantor85621523c_antor
cantos84826973c_antos
canyons124511593c_anyons
canzona1836073c_anzona
canzone1858813c_anzone
canzoni1836153c_anzoni
capon95221873c_a_pon
carbon104919043c_arbon
cardon94120853c_ardon
carton84522663c_arton
cation83925503c_ation
censor84011293c_ensor
chador1238673cha_dor
chads116122233chads__
chaebol1444943chaebol
chagrin1337893chagrin
chain105723673cha__in
chainman1585193chainman
chainmen15105263chainmen
chains114819703chains__
chainsaw1642373chainsaw
chais107530313chais__
chaise114916413chais_e
chaises124317493chaises
chaldron1445773chaldron
challot123613263challot
chalone12312103cha_lone
chalot113020133cha_lot
chamfron1844493chamfron
chamiso14348653chamiso_
chamisos15307423chamisos
champion17276353champion
chams126028503chams__
chance134617093chan_ce
chanced154113213chanced
chancel144011773chancel
chancer144215633chancer
chances145218093chances
chancing162810283chancing
chancre14348783chancre
chancy164010863chan_cy
chanfrons1744623chanfrons
chang115418563chan__g
change124116753chan_ge
changed144214143changed
changer134215543changer
changes134517583changes
changing153211513changing
changs125215373chan_gs
channel123910483channel
chanoyu1544483chanoyu
chant105932693chan__t
chanted134015953chanted
chanter123919733chanter
chantey154112543chantey
chanting143413533chanting
chantors133710263chantors
chantry15388223chantry
chants115020393chan_ts
chanty145215823chan_ty
chao95727313cha__o_
chaos105622863cha__os
chaoses124715123chaoses
chaperon1547353chaperon
chapman1637893chapman
chapmen1637283chapmen
chaps125326063chaps__
chariot12316213chariot
charpoy1735713charpoy
charro114212953charro_
charros124312143charros
chars105936643chars__
chase105127123cha_s_e
chased125019293cha_sed
chaser114918383cha_ser
chases115128233cha_ses
chasing133715893cha_sing
chasm125518793cha_s_m
chasms135513143cha_sms
chasmy16468543cha_smy
chasse115114603cha_sse
chassed134712133chassed
chasses124017503chasses
chassis123910663chassis
chaste114617393cha_ste
chasten124312403chasten
chats105730093chats__
chaws135022463chaws__
chays135319743chays__
chazan20269133cha_zan
chazzan20204853chazzan
chazzen20214783chazzen
chevron1575783chevron
chiffon1844053chiffon
chignon1344623chignon
chinbone1555163chinbone
chino105823313chin_o_
chinone12510153chin_one
chinook1675103chinook
chinos115018693chin_os
chins105631463chins__
chiton112612393ch_iton
chon96627793ch___on
chorion12311773chorion
chosen116014133ch_osen
chrismon1544643chrismon
chrisom1466623chrisom
chronon1237353chronon
clangor10426683clangor
clans75031013clans__
clansman1245813clansman
clansmen1245723clansmen
clarion9311663clarion
classons1037703classons
claxon1536583cla_xon
coarsen93210323coarsen
consol82614113c_onsol
crampon1336943crampon
crannog1044243crannog
craton84517193cra_ton
crayon114110003cra_yon
crimson1135643crimson
cyanin113911453cyan_in
cyano105512493cyan_o_
cyans105714813cyans__
damson938063_damson
fanion94514323_fanion
fanon84619013_fan_on
grandson1055413grandson
hadron102913753_hadron
hagdon1188283_hagdon
halon86124863_ha_lon
hansa85416783_hans_a
hansas94616043_hansas
hanse85722793_hans_e
hansel95214373_hansel
hanses95022633_hanses
hansoms12238523_hansoms
hausen9610383_hausen
hyson1138693_h_yson
johnson1742333johnson
khamsin1643983khamsin
khans124615173khans__
liaison744473liaison
mansion9611543_mansion
mason74820183_ma_son
parson83817903_parson
phaeton1235973phaeton
phantom1436693phantom
phonon114012033phon_on
ramson8310463_ramson
ransom82410943_ransom
reason62616333rea_son
scansion1045693scansion
season62714903sea_son
sponson935383sponson
transom948823transom
wanion93213063_wanion
wanton94413813_wanton
weason93210823wea_son

Search took 10 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.406440125.6
2DLD Change Limit1340271919.14314659.0
3Display Results1911910.1401364.3
 (SQL Overall)1786911919.68918442.7
 
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.