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 “validnesses” 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
validnesses157602(None) 
vapidnesses1774891vapidnesses
acidnesses1337252_acidnesses
algidnesses1345162_algidnesses
aridnesses1139942_aridnesses
avidnesses1436462_avidnesses
baldnesses1337652bal_dnesses
gelidnesses1355982gelidnesses
pallidnesses1543922pallidnesses
rabidnesses1476132rabidnesses
rapidnesses1476472rapidnesses
solidnesses1238102solidnesses
vainnesses1337342va_innesses
validness13125362validne_s_s
vividnesses1844222vividnesses
voidnesses1436842v_oidnesses
acridnesses1445793acridnesses
agednesses1237413_agednesses
aliennesses1145863_aliennesses
alikenesses1547203_alikenesses
alivenesses1448873_alivenesses
badnesses1239253ba__dnesses
balkinesses1767503balkinesses
balminesses1537253balminesses
bandinesses14109733bandinesses
bawdinesses17126323bawdinesses
blandnesses1446623blandnesses
blindnesses1446183_blindnesses
boldnesses1337233bol_dnesses
caginesses13310943cagi_nesses
cakinesses16310613caki_nesses
calmnesses1436843cal_mnesses
candidnesses1685393candidnesses
coldnesses1338423col_dnesses
dailinesses1249493dailinesses
dailynesses1543943dailynesses
datednesses1357903datednesses
dazednesses2245153dazednesses
earlinesses11311043earli_nesses
easinesses10314443easi_nesses
fadednesses16126563fadednesses
fairnesses1357383fa_irnesses
falsenesses1446743falsenesses
fetidnesses1546653fetidnesses
fluidnesses1545483fluidnesses
gaminesses13410463gami_nesses
gaudinesses1337863gaudinesses
gladnesses1236683_gladnesses
glibnesses1344763_glibnesses
halenesses13312043hal_enesses
halfnesses1636263hal_fnesses
handinesses151410273handinesses
hardinesses151110223hardinesses
hardnesses141810543ha_rdnesses
hazinesses2239223hazi_nesses
holinesses13511493holi_nesses
humidnesses1744583humidnesses
jadednesses20145773jadednesses
lacinesses12312123laci_nesses
lazinesses19310153lazi_nesses
lionesses939433__lionesses
lividnesses1545023lividnesses
lucidnesses1445243lucidnesses
luridnesses1246723luridnesses
madnesses1239833ma__dnesses
malenesses12312223mal_enesses
maltinesses13310233maltinesses
manlinesses13910193manli_nesses
matinesses12314543mati_nesses
mazednesses2345403mazednesses
mazinesses2139923mazi_nesses
mealinesses13310973meali_nesses
mildnesses1397393mil_dnesses
moldinesses14138043moldinesses
nakednesses1645843nakednesses
oilinesses101512443oili_nesses
oldnesses1037703_ol_dnesses
ovalnesses1346053oval__nesses
palenesses12312663pal_enesses
placidnesses1743953placidnesses
plainnesses1356203plainnesses
racinesses12313513raci_nesses
rancidnesses1544883rancidnesses
randinesses121311203randinesses
rigidnesses1345923rigidnesses
sadnesses10310303sa__dnesses
saltinesses11311453saltinesses
saltnesses10310163sal_tnesses
sandinesses12911393sandinesses
scalinesses1339323scali_nesses
slimnesses1236423_slimnesses
squalidnesses2352103squalidnesses
staidnesses1237193staidnesses
tacitnesses1336323tacitnesses
talkinesses1537353talkinesses
tallnesses1037473tal_lnesses
tardinesses121110253tardinesses
tepidnesses1445383tepidnesses
timidnesses1445143timidnesses
tumidnesses1444613tumidnesses
uglinesses1138543ugli_nesses
vaguenesses1544813vaguenesses
valiantnesses1652723valiantnesses
vapidness15144423vapidne_s_s
vastnesses13128203va_stnesses
vexednesses2244603vexednesses
vilenesses13310223vil_enesses
warinesses131514523wari_nesses
wavinesses16199283wavi_nesses
waxinesses20138763waxi_nesses
wildnesses14157363wil_dnesses
wilinesses131911093wili_nesses
zaninesses19310383zani_nesses

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit1216331135.01324263.5
3Display Results1131130.0631793.7
 (SQL Overall)1786911135.46632691.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.