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

129 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
nighness123610(None) 
highness1536051highness
bigness1038192big_ness
lightness13107432lightness
niceness1039842niceness
nighest11310692nigh_est
nighnesses1446462nighnesses
nightless1386072nightless
richness1337432richness
rightness13117352rightness
sighless1276552sighless
tightness1386602tightness
airiness8412213airiness
apishness1445743apishness
archness1337513archness
biasness1035813biasness
brightness1644573brightness
caginess11310303caginess
digeneses1147393digeneses
digenesis1145333digenesis
digress938323dig_ress
dimness1038843di_mness
dinginess1137823dinginess
direness9311303direness
edginess1036053edginess
fighters15269403fighters
fineness11310643fineness
firmness1334743firmness
fishiness1537343fishiness
fishless1436413fishless
fishnets1445633fishnets
fitness10299393fi_tness
highest1439563high_est
highnesses1746083highnesses
hipness12277383hi_pness
hugeness1237373hugeness
iciness938863_iciness
illness736473_illness
ingress838653ing_ress
inkiness1238693inkiness
kindness13236653kindness
lightens122510003lightens
lighters123111393lighters
lightest121410353lightest
lightless1386073lightless
likeness12229863likeness
liminess10510643liminess
limpness1246703limpness
lioness739103li_oness
liteness82213213liteness
litheness1247363litheness
liveness112411393liveness
loginess9310163loginess
lushness1136233lushness
mightiness1645093mightiness
mildness1136523mildness
miriness10310463miriness
muchness1534073muchness
naiveness1277493naiveness
nathless11127023nathless
nearness838313nearness
neatness839153neatness
newness1035703n_ewness
niches114419143nich_e_s
niftiness1236363niftiness
niggers93111323nig_gers
nigglers10307253nigglers
niggles93512203niggle_s
nighed113811293nigh_e_d
nigher103612753nigh_e_r
nighs95013613nigh___s
nightdress1552983nightdress
nighties121011383nighties
nights104117723nigh__ts
nimbyness1641543nimbyness
nines55937343ni__ne_s
nippiness1334713nippiness
noisiness948343noisiness
nosiness83211393nosiness
nowness1037033n_owness
nudeness936733nudeness
numbness1234413numbness
oiliness8311563oiliness
pigginess1375453pigginess
pigsneys1442003pigsneys
pinkness1436513pinkness
pipiness1238003pipiness
pithiness1437563pithiness
pithless13117023pithless
pixiness1736093pixiness
poshness1356653poshness
rashness1138093rashness
rifeness1138583rifeness
righters122610713righters
rightest12149583rightest
rigidness1145123rigidness
riminess10510093riminess
ripeness1039363ripeness
roughness1345763roughness
sageness92111983sageness
sickness1437833sickness
sighers113712183sigh_ers
sighters122510603sighters
sightless1385923sightless
signees83510803sig_nees
signers84714443sig_ners
signets83311503sig_nets
siziness1737423siziness
slightness1454803slightness
snideness1067683snideness
snugness934323snug_ness
suchness1335763suchness
tidiness938793tidiness
tightens12297953tightens
tightest12148363tightest
tigress836093tig_ress
tininess8310633tininess
titaness836723titaness
toughness1355093toughness
trigness968403trig_ness
vileness1139983vileness
wideness12259473wideness
wigless11359673wig_less
wildness1236203wildness
wiliness1139113wiliness
wiriness1138953wiriness
wiseness112010753wiseness
wishless1435993wishless
witness103010013wi_tness

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621296.98320931.1
3Display Results1291290.0632047.6
 (SQL Overall)1786911297.49923828.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.