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

167 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
classons103770(None) 
classon937691classon_
caissons1036282caissons
chansons1337472chansons
clarions10310492clarions
classers104111832classers
classes94717942class_es
classics12418872classics
classing113211792classing
classis93712722class_is
claxons1635802cla_xons
lassoes74613852_lassoes
lassos64913812_lasso_s
lessons73811022_lessons
plasmons12217662plasmons
alastors8311203alastors
alations82518893alations
arsons63917213__arsons
basions94213953_basions
bassoons1036553_bassoons
bassos85313703_basso_s
blazons1836163bla_zons
blossoms12134553blossoms
blousons1054403blousons
caisson936593caisson_
caldrons1138063caldrons
camions113916133c_amions
cannons94412883c_annons
canons85522063c_a_nons
cansos84915383c_anso_s
cantons95221203c_antons
canyons124511593c_anyons
capons104119503c_a_pons
carassows1442933carassows
carbons115418943c_arbons
cardons104519933c_ardons
cartons94122473c_artons
caseins93115053c_aseins
caseous9312513c_aseous
caserns94711223c_aserns
cashoos12310793c_ashoos
casinos93512833c_asinos
cassena9287843c_assena
cassenas10317483c_assenas
cassene93111543c_assene
cassenes103611293c_assenes
cassias93514343c_assias
cassina94113163c_assina
cassinas103610633c_assinas
cassine93817283c_assine
cassines103116613c_assines
cassino93512433c_assino
cassinos10309353c_assinos
cassis84818853c_ass_is
cassock1545953c_assock
cassocks1645033c_assocks
castors94919443c_astors
cations94524143c_ations
celadons1137003cela_dons
cessions1039853cessions
chanson1238043chanson_
chasses124017503chass_es
chassis123910663chass_is
chastens13429183chastens
clachans1546413clachans
clamors11710093cla_mors
clangors11417003clangors
clans75031013cla___ns
clarion9311663clarion_
claroes93113733cla_roes
claros84015113cla_ro_s
clashers134213993clashers
clashes124017283cla_shes
clashing143812193clashing
claspers124410913claspers
clasping133310263clasping
clasps104512093cla_s_ps
class75525483cla_s__s
classed104113653class_ed
classer93614613class_er
classic113710113class_ic
classico12386303classico
classier10359083classier
classiest11309543classiest
classify1644693classify
classily1336623classily
classiness12196313classiness
classism12407173classism
classisms13295523classisms
classist104010383classist
classists11296243classists
classless1143843classless
classroom1343513classroom
classrooms1442983classrooms
classwork1843793classwork
classworks1943313classworks
classy11379043class__y
clastics122811413clastics
clasts84817293cla_s_ts
clauses93813323claus_es
claxon1536583cla_xon_
claypans1543873claypans
claystone1444683claystone
claystones1544393claystones
clons75228133cl___ons
coarsens10348123coarsens
colessors1145663colessors
crampons1436643crampons
cratons94316033cra_tons
crayons12439233cra_yons
crimsons1245633crimsons
curassows1441903curassows
cussos84210003c_usso_s
damsons1038013_damsons
eclosions1146203eclosions
elastins82111743elastins
elations83719123elations
elisions82210423elisions
elusions82610083elusions
erasions8310983erasions
evasions1136543evasions
flacons1238053fla_cons
flagons1137973fla_gons
frissons1145043frissons
gascons10289103_gascons
glasses84414273glass_es
glassies94012273glassies
glassine9329313glassine
glassines10278043glassines
glassing10329973glassing
klaxons1833263kla_xons
ladrons83813193_ladrons
lagoons839253_lagoons
lardons83914493_lardons
lashins103915153_lashins
lasses64827593_lass_es
lassies74420103_lassies
lassis65216703_lass_is
lasso55015683_lasso__
lassoed8408743_lassoed
lassoer7379383_lassoer
lassoers8338513_lassoers
lassoing946383_lassoing
lesions73813873_lesions
lessens7409383_lessens
lesson64412043_lesson_
lessors73610523_lessors
liaisons844293liaisons
malisons1048783malisons
mascons113411583_mascons
masons83916513_ma_sons
nasions73112383_nasions
occasions1344063occasions
parsons93516873_parsons
passions10310583_passions
plasmins12199413plasmins
plasmon11257983plasmon_
plastrons1147133plastrons
platoons1038683platoons
plessors10278253plessors
plosions1038023plosions
quassins1735793quassins
ramsons939563_ramsons
reasons72514943rea_sons
seasons72614233sea_sons
suasions838783suasions
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.423422437.4
2DLD Change Limit1461621677.98318309.2
3Display Results1671670.0802087.5
 (SQL Overall)1786911678.48621057.2
 
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.