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

123 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
classily133662(None) 
classify1644691classify
glassily1235461glassily
brassily1336622brassily
clammily1743632clammily
classic113710112classi_c
classico12386302classico
classics12418872classics
classier10359082classier
classing113211792classing
classis93712722classi_s
classism12407172classism
classist104010382classist
classy11379042class__y
clumsily1544002clumsily
crassly1276652crass_ly
flashily1735472flashily
flossily1434522flossily
gassily1137812_gassily
glossily1235092glossily
grassily1236432grassily
sassily1038722_sassily
bassly114610073_bass_ly
blousily1345193blousily
blowsily1643953blowsily
bossily1237563_bossily
cagily12411563c_a_gily
campily1638273c_ampily
cannily1239263c_annily
cassia83714763c_assi_a
cassias93514343c_assias
cassina94113163c_assina
cassine93817283c_assine
cassino93512433c_assino
cassis84818853c_assi_s
cattily123210853c_attily
chancily1845243chancily
charily15310283cha_rily
chassis123910663chassi_s
chastely1635813chastely
chastity1645273chastity
chattily1634603chattily
cheesily1654413cheesily
chestily1645523chestily
clarify1536093cla_rify
clarity12310913cla_rity
clashing143812193clashing
clasping133310263clasping
class75525483class___
classable1347143classable
classed104113653class_ed
classer93614613class_er
classers104111833classers
classes94717943class_es
classical1345293classical
classically1844953classically
classicals1443903classicals
classiest11309543classiest
classisms13295523classisms
classists11296243classists
classon937693class_on
classons1037703classons
clastic113013963clasti_c
clastics122811413clastics
clausal936273clausal_
cloggily1543243cloggily
closely1237053cl_osely
cloudily1444283cloudily
coarsely1335533coarsely
coassist10298803coassist
cosily113613853c__osily
crabbily1744343crabbily
craftily1644783craftily
craggily1543703craggily
crankily1755623crankily
crazily2136923cra_zily
crispily1574693crispily
crossly1277273cross_ly
crusily12199093c_rusily
crustily13328173crustily
cushily15257923c_ushily
declassify1952233declassify
dressily1246443dressily
easily9313023_ea_sily
flabbily1843353flabbily
flakily1736293fla_kily
fleshily1744533fleshily
flimsily1643283flimsily
fussily13267603_fussily
glassie8329493glassi_e
glassier9289083glassier
glassies94012273glassies
glassine9329313glassine
glassing10329973glassing
glassy10527753glass__y
glazily2035383gla_zily
hastily133010663_hastily
lacily11612763_la_cily
lankily1437123_lankily
lassi56316853_lassi__
lassie64917743_lassi_e
lassies74420103_lassies
lassis65216703_lassi_s
lastly93310873_la_stly
lazily1859713_la_zily
lousily1038333_lousily
lustily103611243_lustily
messily12298813_messily
mussily12279773_mussily
nastily103011033_nastily
plaguily1443513plaguily
plasticly1644763plasticly
plausibly1643113plausibly
plushily1664423plushily
prissily1346693prissily
reclassify1852463reclassify
slangily1235383slangily
slushily1445013slushily
splashily1742963splashily
tastily103311643_tastily
trashily1437323trashily
waspily1535513_waspily
yeastily1444573yeastily

Search took 7 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 Limit1461621236.67021913.3
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.87226002.8
 
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.