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

162 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
vilenesses1331022(None) 
agilenesses1247772agilenesses
direnesses11311482direnesses
evilnesses1346002evil_nesses
finenesses13310712finenesses
halenesses13312042halenesses
idlenesses1138032idlenesses
illnesses937282_illnesses
likenesses1449532likenesses
litenesses10513022litenesses
livenesses13411072livenesses
malenesses12312222malenesses
mildnesses1397392mildnesses
nicenesses12310352nicenesses
oilinesses101512442oilinesses
palenesses12312662palenesses
rifenesses1339942rifenesses
ripenesses12310372ripenesses
solenesses10412702solenesses
vileness1139982vilene_s_s
widenesses1438772widenesses
wildnesses14157362wildnesses
wilinesses131911092wilinesses
wisenesses13310822wisenesses
airinesses102613613airinesses
aliennesses1145863aliennesses
alikenesses1547203alikenesses
alivenesses1448873alivenesses
amplenesses1585703amplenesses
avidnesses1436463avi_dnesses
baldnesses1337653baldnesses
barenesses12311703barenesses
basenesses12310563basenesses
biasnesses1236963biasnesses
bignesses1267963bi_gnesses
bluenesses1237933bluenesses
boldnesses1337233boldnesses
calmnesses1436843calmnesses
chillnesses1644723chillnesses
civilnesses1644853civil_nesses
coldnesses1338423coldnesses
cutenesses12910903cutenesses
dailinesses1249493dailinesses
dailynesses1543943dailynesses
digeneses1147393digene_ses
dilutenesses1346113dilutenesses
dimnesses1238213di_mnesses
donenesses11310563donenesses
duenesses1039333_duenesses
dullnesses1135993dullnesses
dulnesses1037763dul_nesses
ediblenesses1545833ediblenesses
facilenesses1756723facilenesses
falsenesses1446743falsenesses
fellnesses1346083fellnesses
ficklenesses2144153ficklenesses
filminesses1636233filminesses
finesses111912343fi__nesses
firmnesses1535613firmnesses
fitnesses12219373fi_tnesses
fixednesses2244853fixednesses
freenesses1339873freenesses
fullnesses1336213fullnesses
fulnesses1239053ful_nesses
futilenesses1547213futilenesses
gamenesses1368983gamenesses
glegnesses1245073_glegnesses
glibnesses1344753glibnesses
gonenesses11310253gonenesses
halfnesses1636263halfnesses
highnesses1746083highnesses
hillinesses1458503hillinesses
hipnesses1436753hi_pnesses
holinesses13511493holinesses
hugenesses1437143hugenesses
icinesses11310073_icinesses
kindnesses1537213kindnesses
lamenesses12610563lamenesses
latenesses10413363latenesses
liminesses121310853liminesses
limpnesses14116653limpnesses
lionesses939433li_onesses
lithenesses1447313lithenesses
littlenesses1246093littlenesses
lonenesses10311343lonenesses
milkinesses1786793milkinesses
mirinesses121512313mirinesses
morenesses12811393morenesses
mutenesses1289973mutenesses
naivenesses1449113naivenesses
nighnesses1446463nighnesses
nimblenesses1656013nimblenesses
noblenesses1348073noblenesses
nudenesses1157863nudenesses
oldnesses1037703_oldnesses
onenesses9311823_onenesses
ovalnesses1346053oval_nesses
pinknesses1636583pinknesses
pipinesses1448603pipinesses
pixinesses1937373pixinesses
primenesses1548993primenesses
purenesses12810743purenesses
rarenesses10313113rarenesses
richnesses1537803richnesses
riminesses121211413riminesses
rudenesses1188873rudenesses
safenesses1349373safenesses
sagenesses11510823sagenesses
saltnesses10310163saltnesses
samenesses12410853samenesses
sanenesses10412693sanenesses
selfnesses1335893selfnesses
servilenesses1646303servilenesses
sicknesses1636763sicknesses
sidednesses1347103sidednesses
silentnesses1275443silentnesses
silkinesses1557903silkinesses
sillinesses1169843sillinesses
simplenesses1645623simplenesses
singlenesses1346103singlenesses
sizinesses1938653sizinesses
slimnesses1236423slimnesses
slynesses1235863_slynesses
snidenesses1248653snidenesses
sorenesses101313493sorenesses
stalenesses11311103stalenesses
stillnesses1146733stillnesses
surenesses101212213surenesses
sveltenesses1545233sveltenesses
tallnesses1037473tallnesses
tamenesses1259973tamenesses
tidinesses1139223tidinesses
tininesses10311163tininesses
tirednesses1247743tirednesses
titanesses1037253titanesses
tritenesses11710393tritenesses
truenesses1039313truenesses
tweenesses1345803tweenesses
uglinesses1138543uglinesses
vaguenesses1544813vaguenesses
vainnesses1337343vainnesses
validnesses1576023validnesses
vastnesses13128203vastnesses
vexednesses2244603vexednesses
victresses1544973victresses
villainesses1543513villainesses
vinasses1135703vi__nasses
visiblenesses1855323visiblenesses
vitalnesses1456273vitalnesses
vitesses1136333vi__tesses
vividnesses1844223vividnesses
voidnesses1436843voidnesses
votivenesses1847583votivenesses
waenesses1239773_waenesses
wellnesses1335783wellnesses
whitenesses1746653whitenesses
wholenesses1745803wholenesses
wildernesses1643623wildernesses
wirelesses1345333wirelesses
wirinesses131811523wirinesses
witnesses12219923wi_tnesses
woenesses1239133_woenesses

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.436409841.7
2DLD Change Limit1406031625.47025704.4
3Display Results1621620.0762131.6
 (SQL Overall)1786911625.98229871.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.