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

169 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
richness133743(None) 
archness1337512archness
highness1536052highness
iciness938862_iciness
muchness1534072muchness
niceness1039842niceness
nighness1236102nighness
raciness102413452raciness
rashness1138092rashness
richens12349732rich_ens
riches115022082rich_e_s
richest122813682rich_est
richnesses1537802richnesses
rifeness1138602rifeness
rightness13117352rightness
riminess10510102riminess
ripeness1039372ripeness
sickness1437832sickness
suchness1335762suchness
achiness1339703_achiness
acidness1136723acidness
airiness8412223airiness
apishness1445753apishness
aridness939233ari_dness
biasness1035813biasness
bigness1038193bi_gness
bitchiness1743793bitchiness
brashness1436323brashness
briefness1444113briefness
brightness1644573brightness
brininess1138223brininess
briskness1544773briskness
butchness1643453butchness
chess105016923__ch_ess
chicness1535593chic_ness
crispness1345313crispness
dimness1038843di_mness
direness9311303direness
duchess1335553duch_ess
erectness1146123erectness
fiches145219533fich_e_s
fineness11310653fineness
firmness1334743firmness
fishiness1537343fishiness
fishless1436413fishless
fishnets1445633fishnets
fitness10299393fi_tness
freshness1545943freshness
garishness1445763garishness
griminess1236723griminess
grimness1176003gri_mness
hipness12277383hi_pness
iceless9219963_iceless
ickiness1436753_ickiness
icones84616383_icone_s
illness736473_illness
ironness836953ironness
itchiness1444753itchiness
juiciness1835153juiciness
kindness13236653kindness
laciness102112553laciness
licenses10118923licenses
lichees123512783lich_ees
lichens123510683lich_ens
liches114724293lich_e_s
licitness1145373licitness
lightness13107433lightness
likeness12229863likeness
liminess10510643liminess
limpness1246703limpness
lioness739103li_oness
liteness82213213liteness
litheness1247363litheness
liveness112411393liveness
lushness1136233lushness
miches134320733mich_e_s
mildness1136523mildness
miriness10310463miriness
niches114419143nich_e_s
oiliness8311563oiliness
packness1636933packness
pickiness1737623pickiness
pinkness1436513pinkness
pipiness1238003pipiness
pithiness1437563pithiness
pithless13117023pithless
pixiness1736093pixiness
poshness1356653poshness
priceless1336893priceless
primeness1338663primeness
primness1276763pri_mness
quickness2443733quickness
rachets124516833rach_ets
rachises131412413rachises
raininess949293raininess
rakishness1744613rakishness
ranchless1444453ranchless
rankness12267943rankness
raptness1046733raptness
rareness81112853rareness
rawness1038153r_awness
realness8410443realness
recanes93222263recane_s
recess8314263rec__ess
rechews1537293rech_ews
reckless14257973reckless
redness82012443r_edness
ribless93410343ri_bless
ricers84120993ric__ers
rices75536153ric__e_s
richen113812513rich_e_n
richened1435953richened
richer114015043rich_e_r
richweed17163583richweed
richweeds18132813richweeds
ricins83618703ricin__s
ricinus9408123ricin_us
ricinuses1144563ricinuses
rickets134915093ric_kets
rickeys16548983ric_keys
rictuses1037563rictuses
riftless1136943riftless
righters122610713righters
rightest12149583rightest
rigidness1145123rigidness
rimless9369363ri_mless
rindless92510203rindless
rinses64720383ri__nses
ripeners1036843ripeners
riskiness1336973riskiness
riskless1235763riskless
ritziness1835833ritziness
rochets124213473roch_ets
rockiness15237833rockiness
rockless14297293rockless
ropiness102311073ropiness
rosiness82613183rosiness
roughness1345763roughness
ruches114819583ruch_e_s
rudeness938083rudeness
ruthless1135413ruthless
sighless1276553sighless
siziness1737423siziness
slickness1535903slickness
spiciness1347053spiciness
strictness1245643strictness
thickness1844443thickness
tidiness938793tidiness
tightness1386603tightness
tininess8310633tininess
titaness836723titaness
trichoses14107963trichoses
trickiness1666363trickiness
trigness968403tri_gness
trimness1067563tri_mness
triteness9310373triteness
viceless1337983viceless
vichies15310623vichie_s
victress1344523victress
vileness1139983vileness
wiches144418753wich_e_s
wickless1736083wickless
wideness12259473wideness
wildness1236203wildness
wiliness1139113wiliness
wiriness1138953wiriness
wiseness112010753wiseness
wishless1435993wishless
witness103010013wi_tness

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.436409841.7
2DLD Change Limit1461621697.84618628.9
3Display Results1691690.0632682.5
 (SQL Overall)1786911698.34521412.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.