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 “cleanness” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
cleanness114497(None) 
clearness1135631clearness
leanness837371_leanness
bleakness1543592bleakness
cheapness1643742cheapness
cleaners103610542clea_ners
cleanest10310292clea_nest
cleanliness1343262cleanliness
cleannesses13135822cleannesses
cleansers11335062cleansers
cleanses10358142cleanse_s
meanness1037182_meanness
uncleanness1352842uncleanness
alertness946053alertness
alienness945373alienness
blandness1235973bl_andness
blankness1544673bl_ankness
bleariness1246053bleariness
cannels93413363c__annels
canners93822663c__anners
canoness1039393c__anoness
channels13388493c_hannels
chewiness1744823chewiness
clangers114312343cl_angers
clannish1345263cl_annish
clawless1334123cl_awless
cleaned103512003clea_ne_d
cleaner93712303clea_ne_r
cleanliest1244353cleanliest
cleans85817053clea_n__s
cleanse9358723clea_n_se
cleansed11395933cleanse_d
cleanser10356313cleanse_r
cleanups1242203clea_nups
clearers10349303clea_rers
clearest1038653clea_rest
clearnesses13106153clearnesses
cleavers13398873clea_vers
cleaves124111623clea_ve_s
cleverness1543223cleverness
closeness1137613closeness
creakiness1645963creakiness
creaminess1446203creaminess
deadness1039233_deadness
deafness1236213_deafness
dearness939973_dearness
evenness1135543eve_nness
flannels1134843fl_annels
flatness1138153fl_atness
fleetness1244753fleetness
gladness1036153gl_adness
gleaners9348073glea_ners
glegness1034613gle_gness
greatness1036903greatness
greenness1046793greenness
humanness1443793humanness
keenness1234883_keenness
lankness12237043_l_ankness
lanners73618333_l_anners
laxness1436043_l_axness
leadenness1144443_leadenness
leadless9248793_leadless
leafiness1236483_leafiness
leafless11246573_leafless
leakiness1337503_leakiness
leakless12246983_leakless
leaners73718173_lea_ners
leanest7415863_lea_nest
leannesses10108343_leannesses
learners8398153_learners
lewdness1254173_lewdness
lornness836493_lornness
nearness838313_nearness
neatness839153_neatness
oleanders1035573oleanders
openness1035473ope_nness
plainness1155183plainness
planeness1138153pl_aneness
planless1036813pl_anless
planners10399933pl_anners
pleatless1134613pleatless
pliantness1263643pliantness
realness8410443_realness
sleaziness19104703sleaziness
sleekness1344543sleekness
solemnness1243213solemnness
sternness946093sternness
wanness102610683__wanness
weakness1535353_weakness
womanness1444473womanness

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 Filter1786911486410.436409841.7
2DLD Change Limit148641907.58019609.6
3Display Results90900.0461956.5
 (SQL Overall)178691908.06222164.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.