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

183 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
classon93769(None) 
classons1037701classons
caisson936592caisson
chanson1238042chanson
clarion9311662clarion
class75525482class__
classed104113652classed
classer93614612classer
classes94717942classes
classic113710112classic
classing113211792classing
classis93712722classis
classy11379042class_y
claxon1536582cla_xon
lasso55015682_lasso_
lassos64913812_lassos
lesson64412042_lesson
plasmon11257982plasmon
alastor739653alastor
alation72920553alation
arson55118833__arson
basion84315853_basion
basso76017283_basso_
bassoon937613_bassoon
bassos85313703_bassos
blazon1736763bla_zon
blossom11114963blossom
blouson974893blouson
caissons1036283caissons
cajon144513903c_a_jon
caldron1038153caldron
camion103917193c_amion
cannon84514443c_annon
canon74725303c_a_non
canso75019403c_anso_
cansos84915383c_ansos
canton85722993c_anton
canyon114512033c_anyon
capon95221873c_a_pon
carassow1343253carassow
carbon104919043c_arbon
cardon94120853c_ardon
carton84522663c_arton
casein83216453c_asein
casern84713313c_asern
cashoo11312253c_ashoo
casino84317553c_asino
cassena9287843c_assena
cassene93111543c_assene
cassia83714763c_assia
cassina94113163c_assina
cassine93817283c_assine
cassino93512433c_assino
cassis84818853c_assis
cassock1545953c_assock
castor84418533c_astor
cation83925503c_ation
celadon1036913cela_don
cession939813cession
chansons1337473chansons
chasse115114603chass_e
chassed134712133chassed
chasses124017503chasses
chassis123910663chassis
chasten124312403chasten
clachan1437183clachan
clads85722733clads__
clags85621123clags__
clamor1049453cla_mor
clams95127673clams__
clan65633923cla___n
clangor10426683clangor
clans75031013clans__
clansman1245813clansman
clansmen1245723clansmen
claps95626183claps__
clarions10310493clarions
claro75018693cla_ro_
claros84015113cla_ros
clash106219033cla_s_h
clashed133614013clashed
clasher124615513clasher
clashes124017283clashes
clashing143812193clashing
clasp95517193cla_s_p
clasped123610443clasped
clasper113811863clasper
clasping133310263clasping
clasps104512093cla_sps
claspt104513413cla_spt
classers104111833classers
classico12386303classico
classics12418873classics
classier10359083classier
classify1644693classify
classily1336623classily
classism12407173classism
classist104010383classist
classroom1343513classroom
classwork1843793classwork
clast76030583cla_s_t
clastic113013963clastic
clasts84817293cla_sts
clausal936273clausal
clause84311503claus_e
clauses93813323clauses
claws106020833claws__
claxons1635803cla_xons
claypan1434313claypan
clays105521333clays__
claystone1444683claystone
clon66232483cl___on
coarsen93210323coarsen
colessor1045233colessor
crampon1336943crampon
crass76328043crass__
crasser94114343crasser
crassly1276653crassly
craton84517193cra_ton
crayon114110003cra_yon
crimson1135643crimson
curassow1342013curassow
cusso74912293c_usso_
cussos84210003c_ussos
damson938063_damson
eclosion1046893eclosion
elastin72611843elastin
elation73620453elation
elision72311103elision
elusion72310953elusion
erasion7311963erasion
evasion1036753evasion
flacon1138633fla_con
flagon1037983fla_gon
frisson1045313frisson
gascon9339723_gascon
glass65518133glass__
glassed93710433glassed
glasses84414273glasses
glassie8329493glassie
glassine9329313glassine
glassing10329973glassing
glassman1145183glassman
glassmen1145393glassmen
glassy10527753glass_y
klaxon1733853kla_xon
ladron73413323_ladron
lagoon7410483_lagoon
lardon74415063_lardon
lass47444543_lass__
lasses64827593_lasses
lassi56316853_lass_i
lassie64917743_lassie
lassis65216703_lassis
lassoed8408743_lassoed
lassoer7379383_lassoer
lassoes74613853_lassoes
lassoing946383_lassoing
lesion64715063_lesion
lessen64212433_lessen
lessons73811023_lessons
lessor64010603_lessor
liaison744473liaison
lissom837403_lissom
malison939693malison
mascon103612743_mascon
mason74820183_ma_son
nasion63914083_nasion
occasion1244213occasion
parson83817903_parson
passion9310883_passion
plasmin112410033plasmin
plasmons12217663plasmons
plastron1046913plastron
platoon938953platoon
plessor9317693plessor
plosion939113plosion
quassin1645943quassin
ramson8310463_ramson
reason62616333rea_son
season62714903sea_son
suasion739363suasion
weason93210823wea_son

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.406440125.6
2DLD Change Limit1340271837.23318529.9
3Display Results1831830.0632904.8
 (SQL Overall)1786911837.70223200.6
 
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.