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

101 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
closeness113761(None) 
aloneness957312aloneness
closenesses1347842closenesses
cosiness103214282c_osiness
crossness1137092crossness
loneness8512092_loneness
looseness937482looseness
lostness837682_lostness
alikeness1336333alikeness
aliveness1238223aliveness
aloofness1242493aloofness
baseness10910943_baseness
blondness1234963blondness
blowiness1435623blowiness
blueness1038213bl_ueness
cassenes103611293cassene_s
causeless1135193causeless
ceaseless1135733ceaseless
chasteness1546523chasteness
choiceness1743773choiceness
classiness12196313classiness
classless1143843classless
cleanness1144973cleanness
clearness1135633clearness
cleverness1543223cleverness
cloistress1242713cloistress
cloners94514823clo__ners
clones84526563clo__ne_s
closeouts1143633closeouts
closers94415323clos__ers
closes85425593clos__e_s
closest94312533clos__est
closeted1135613closete_d
closets94611603clos__ets
closeups12102813close_ups
closings11277673closin_gs
closures10228953closure_s
cloudiness1344113cloudiness
cloudless1243153cloudless
clueless1035883cl_ueless
clumsiness1444333clumsiness
coarseness1246173coarseness
codeless112010113c_odeless
coldness1137953c_oldness
coolness1037743c_oolness
coreless103013833c_oreless
cosines94122673c_osine_s
costless10310003c_ostless
coyness1277323c_o_yness
cozeners19297783c_ozeners
coziness19319823c_oziness
crassness1136213crassness
crispness1345313crispness
crudeness1245753crudeness
cursedness1344463cursedness
cussedness1342843cussedness
cuteness1039673c_uteness
denseness1046863denseness
doneness9411513_doneness
falseness1236093falseness
flushness1544893flushness
glossiness11284993glossiness
goneness9310763_goneness
grossness1045973grossness
jocoseness1943313jocoseness
lameness102612673_lameness
lateness82614073_lateness
likeness12229863_likeness
liteness82213213_liteness
liveness112411393_liveness
loginess9310163_loginess
longness938553_longness
looseners945413looseners
lornness836493_lornness
lossless835473_lossless
loudness937013_loudness
lousiness9219043_lousiness
loveless1168573_loveless
lowness1037813_lo_wness
lushness1136233_lushness
moreness10911573_moreness
moroseness1246223moroseness
noseless839513_noseless
nosiness83211393_nosiness
obeseness1145893obeseness
oneness7512143__oneness
otioseness1045053otioseness
planeness1138153planeness
plushness1444623plushness
poshness1356653_poshness
proneness11310443proneness
prosiness11311693prosiness
rosiness82613183_rosiness
slowness1135013slo_wness
soleness8814263_soleness
soreness8914793_soreness
tenseness947113tenseness
terseness948403terseness
wholeness1545373wholeness
wiseness112010753_wiseness
woeness1020211543_wo_eness

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411017.42020032.5
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.90622601.9
 
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.