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

134 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
validness1312536(None) 
vapidness15144421vapidness
acidness1136722_acidness
algidness1144272_algidness
aridness939222_aridness
avidness1246112_avidness
baldness1137042bal_dness
gelidness1144472gelidness
pallidness1343282pallidness
rabidness12145262rabidness
rapidness12155472rapidness
solidness1036902solidness
vainness1136062va_inness
validnesses1576022validnesses
valines104520212vali_ne_s
vividness1643932vividness
voidness1235552v_oidness
acridness1245073acridness
agedness1036683_agedness
aidless83612073_a_idless
alienees8118653_alienees
alieners889823_alieners
alienness945373_alienness
aligners9117573_aligners
alikeness1336333_alikeness
aliners74717723_ali_ners
alines65735223_ali_ne_s
aliveness1238223_aliveness
badness1039573ba__dness
balkiness1556903balkiness
balminess1356593balminess
bandiness122310243bandiness
bawdiness15235543bawdiness
blandness1235973blandness
blindness1235343_blindness
boldness1136973bol_dness
caginess11310303cagi_ness
cakiness1449553caki_ness
calmness1236643cal_mness
candidness1444773candidness
coldness1137953col_dness
dailiness1038673dailiness
dailyness1343643dailyness
datedness1187753datedness
dazedness20114963dazedness
earliness939693earli_ness
easiness8313043easi_ness
fadedness1445613fadedness
fairness1136563fa_irness
falseness1236093falseness
fetidness1345443fetidness
fluidness1344293fluidness
gaminess112911063gami_ness
gaudiness1136253gaudiness
gladness1036153_gladness
glibness1134133_glibness
haleness11312623hal_eness
halfness1435563hal_fness
halides113416663halid_e_s
handiness132110933handiness
hardiness132310363hardiness
hardness122411083ha_rdness
haziness20248513hazi_ness
holiness112512503holi_ness
humidness1544023humidness
jadedness1844693jadedness
laciness102112553laci_ness
laziness17239983lazi_ness
lidless8309273__lidless
lioness739103__lioness
lividness1344713lividness
lucidness1244313lucidness
luridness1045193luridness
madness10310073ma__dness
maleness10312313mal_eness
maligners12104783maligners
malines93625603mali_ne_s
maltiness112910573maltiness
manliness111310123manli_ness
matiness102114753mati_ness
mazedness2194573mazedness
maziness19239543mazi_ness
mealiness11310063meali_ness
mildness1136523mil_dness
moldiness12227053moldiness
nakedness1445043nakedness
oiliness8311563oili_ness
oldness836403_ol_dness
ovalness1134673oval__ness
paleness10312983pal_eness
placidness1553303placidness
plainness1155183plainness
raciness102413453raci_ness
rancidness1344223rancidness
randiness102511443randiness
rigidness1145123rigidness
sadness8310613sa__dness
salines74029413sali_ne_s
saltiness93312113saltiness
saltness82610243sal_tness
sandiness102111713sandiness
scaliness1149303scali_ness
slimness1036523_slimness
squalidness2141923squalidness
staidness1037033staidness
tacitness1134873tacitness
talkiness1356913talkiness
tallness837103tal_lness
tardiness10229923tardiness
tepidness1244343tepidness
timidness1244623timidness
tumidness1243843tumidness
ugliness936863ugli_ness
vagueness1343933vagueness
vahines133410523vahi_ne_s
vainest10315763va_i_nest
valiances1487203valiances
valiantness1452313valiantness
valiants1137793valian_ts
validates1338243validates
valine94623093vali_ne__
valises103516263vali_se_s
valueless1242843valueless
valveless1543163valveless
vapidnesses1774893vapidnesses
vastness11257293va_stness
vexedness2043863vexedness
vileness1139983vil_eness
wariness11313213wari_ness
waviness1437723wavi_ness
waxiness1836723waxi_ness
wildness1236203wil_dness
wiliness1139113wili_ness
zaniness1738663zani_ness

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.423422437.4
2DLD Change Limit1486411346.92021479.9
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.38924183.4
 
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.