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

113 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
fullnesses133621(None) 
dullnesses1135991dullnesses
fellnesses1346081fellnesses
fulnesses1239051fu_lnesses
dulnesses1037762du_lnesses
foulnesses1337932foulnesses
fullness1135442fullne_s_s
illnesses937282_illnesses
tallnesses1037472tallnesses
wellnesses1335782wellnesses
adultnesses1244833adultnesses
awfulnesses1744943awfu_lnesses
baldnesses1337653baldnesses
bluenesses1237933bluenesses
boldnesses1337233boldnesses
bulginesses1466133bulginesses
bulkinesses1786483bulkinesses
bullnoses1144703bulln_oses
burlinesses1338403burlinesses
businesses121411393businesses
busynesses15145513busynesses
calmnesses1436843calmnesses
chillnesses1644723chillnesses
coldnesses1338423coldnesses
coolnesses1237193coolnesses
cruelnesses1346253cruelnesses
curlinesses1338733curlinesses
curtnesses1238373curtnesses
cutenesses12910903cutenesses
drollnesses1244363drollnesses
duenesses1039333du_enesses
dullness934873dullne_s_s
dumbnesses1584603dumbnesses
dunnesses1037703du_nnesses
evilnesses1346003evilnesses
fairnesses1357383fairnesses
fallownesses1852373fallownesses
falsenesses1446743falsenesses
farnesses122310813f_arnesses
fastnesses1389083fastnesses
fatalnesses1456283fatalnesses
fatnesses121710463f_atnesses
faultinesses1545183faultinesses
fellness1135913fellne_s_s
fewnesses1534953f_ewnesses
feynesses1535223f_eynesses
filminesses1636233filminesses
finenesses13310723finenesses
finesses111912343f__inesses
firmnesses1535613firmnesses
fitnesses12219373f_itnesses
flatnesses1337763flatnesses
fluidnesses1545483fluidnesses
flukinesses1836093flukinesses
flushnesses1745383flushnesses
fondnesses1437703fondnesses
foxinesses20127733foxinesses
fozinesses22158193fozinesses
frailnesses1447593frailnesses
freenesses1339873freenesses
fulleries1248723full_eries
fulness10248963fu_lne_s_s
funkinesses18137003funkinesses
funninesses14106873funninesses
furrinesses1437183furrinesses
fussinesses13126943fussinesses
fustinesses14129783fustinesses
futilenesses1547213futilenesses
fuzzinesses2243723fuzzinesses
gluinesses1138243gluinesses
glumnesses1344733glumnesses
halenesses13312043halenesses
halfnesses1636263halfnesses
hillinesses1458503hillinesses
holinesses13511493holinesses
hugenesses1437143hugenesses
idlenesses1138033idlenesses
jollinesses1836723jollinesses
justnesses1736493justnesses
lushnesses1337343lushnesses
malenesses12312223malenesses
mildnesses1397393mildnesses
muchnesses1744713muchnesses
mutenesses1289973mutenesses
nudenesses1157863nudenesses
numbnesses1474693numbnesses
oilinesses101512443oilinesses
oldnesses1037703_oldnesses
ovalnesses1346053ovalnesses
palenesses12312663palenesses
pulpinesses1536003pulpinesses
puninesses121110753puninesses
purenesses12810743purenesses
realnesses10310853realnesses
rudenesses1188873rudenesses
saltnesses10310163saltnesses
selfnesses1335893selfnesses
sillinesses1169843sillinesses
slynesses1235863_slynesses
smallnesses1344963smallnesses
solenesses10412703solenesses
stillnesses1146733stillnesses
suchnesses1536673suchnesses
sulkinesses1557723sulkinesses
sullennesses1244343sullennesses
sultanesses1145563sultanesses
surenesses101212213surenesses
surlinesses11310053surlinesses
uglinesses1138543uglinesses
usualnesses1144693usualnesses
vilenesses13310223vilenesses
wildnesses14157363wildnesses
wilinesses131911093wilinesses

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 Filter1786911406030.420425454.8
2DLD Change Limit1406031135.95323618.8
3Display Results1131130.0631793.7
 (SQL Overall)1786911136.43627764.3
 
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.