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

145 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
idleness93684(None) 
direness9311302direness
dueness82310122_dueness
haleness11312622haleness
idlenesses1138032idlenesses
idlesses936002idlesses
illness736472i_llness
isleless834852isleless
maleness10312312maleness
paleness10312982paleness
soleness8814262soleness
vileness1139982vileness
wideness12259472wid_eness
adultness1043973adultness
agileness1046493agileness
aidless83612073aidl__ess
ampleness1345303ampleness
baldness1137043baldness
bareness10912813bareness
baseness10910943baseness
blueness1038213blueness
boldness1136973boldness
calmness1236643calmness
coldness1137953coldness
cuteness1039673cuteness
deepness1136443_deepness
denes65639723_d_ene_s
dienes75719903_diene_s
digeneses1147393digeneses
digenesis1145333digenesis
diluteness1145193diluteness
dimness1038843_dimness
doneness9411513doneness
dryness11114783_dryness
dullness934873dullness
dulness8307983_dulness
dunness8298983_dunness
edgeless1034883edgeless
edginess1036053edginess
edibleness1345293edibleness
falseness1236093falseness
fellness1135913fellness
fickleness1943663fickleness
fineness11310643fineness
flenses1039473_flenses
freeness11710443freeness
fullness1135443fullness
fulness10248963ful_ness
gameness112810693gameness
giddiness1234683giddiness
glegness1034613_glegness
godliness1136593godliness
goneness9310763goneness
halfness1435563halfness
hiddenness1542193hiddenness
hideless12278713hid_eless
hilliness1248923hilliness
holeless1189363holeless
holiness112512503holiness
hugeness1237373hugeness
iceless9219963i_celess
iciness938863i_ciness
ickiness1436753ickiness
idealess935653idealess
idlers74012813idl__ers
idles66720123idl__e_s
idlesse834193idle_sse
idlest74014863idl__est
iffiness1435023iffiness
ileuses738673i_leuses
ilexes134510253i_lexe_s
inaneness948383inaneness
incenses102411003incenses
indenes82916253indene_s
inkiness1238693inkiness
innerness946913innerness
inverness1247133inverness
irateness9310493irateness
ireless72312243i_reless
ironness836953ironness
kindliness1544043kindliness
lameness102612673lameness
lateness82614073lateness
lenes54738523__lene_s
lenses64620893__lenses
lidless8309273lidl__ess
likeness12229863likeness
liteness82213213liteness
litheness1247363litheness
littleness1045023littleness
liveness112411393liveness
loneness8512093loneness
midlines112613333midline_s
mildness1136523mildness
moreness10911573moreness
muteness1039013muteness
niceness1039843niceness
nimbleness1445593nimbleness
nobleness1147523nobleness
nudeness936733nudeness
oddness935313od_dness
oiliness8311563oiliness
oldness836403_oldness
oneness7512143_oneness
pileless1088623pileless
poleless1089873poleless
pureness101110183pureness
rareness81112853rareness
rifeness1138583rifeness
ripeness1039363ripeness
rudeness938083rudeness
ruleless836633ruleless
safeness11239633safeness
sageness92111983sageness
saltness82610243saltness
sameness102712683sameness
saneness82313723saneness
selfness1135153selfness
sidedness1146783sidedness
silliness9510363silliness
simpleness1445173simpleness
singleness1145733singleness
slyness1035263_slyness
snideness1067683snid_eness
soleless8910033soleless
soreness8914793soreness
staleness9310783staleness
sureness8912903sureness
tallness837103tallness
tameness102411253tameness
tideless9269083tid_eless
tidiness938793tid_iness
trueness838693trueness
tweeness11246403tweeness
ugliness936863ugliness
waeness102512783_waeness
wellness1135793wellness
wholeness1545373wholeness
wideners12257993wid_eners
wilderness1443513wilderness
wildness1236203wildness
wiliness1139113wiliness
wiseness112010753wiseness
woeness1020211543_woeness
xylenes1745093xylene_s

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.500357382.0
2DLD Change Limit1461621458.20317818.1
3Display Results1451450.0632301.6
 (SQL Overall)1786911458.76620384.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.