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
vilenesses1331021(None) 
agilenesses1247752agilenesses
direnesses11311482direnesses
evilnesses1345982evil_nesses
finenesses13310712finenesses
halenesses13312032halenesses
idlenesses1138022idlenesses
illnesses937272_illnesses
likenesses1449532likenesses
litenesses10513002litenesses
livenesses13411052livenesses
malenesses12312202malenesses
mildnesses1397392mildnesses
nicenesses12310332nicenesses
oilinesses101512432oilinesses
palenesses12312652palenesses
rifenesses1339932rifenesses
ripenesses12310362ripenesses
solenesses10412702solenesses
vileness1139982vilene_s_s
widenesses1438772widenesses
wildnesses14157362wildnesses
wilinesses131911082wilinesses
wisenesses13310802wisenesses
airinesses102613603airinesses
aliennesses1145863aliennesses
alikenesses1547193alikenesses
alivenesses1448853alivenesses
amplenesses1585703amplenesses
avidnesses1436463avi_dnesses
baldnesses1337643baldnesses
barenesses12311693barenesses
basenesses12310553basenesses
biasnesses1236943biasnesses
bignesses1267953bi_gnesses
bluenesses1237923bluenesses
boldnesses1337223boldnesses
calmnesses1436833calmnesses
chillnesses1644713chillnesses
civilnesses1644843civil_nesses
coldnesses1338423coldnesses
cutenesses12910873cutenesses
dailinesses1249493dailinesses
dailynesses1543943dailynesses
digeneses1147393digene_ses
dilutenesses1346103dilutenesses
dimnesses1238213di_mnesses
donenesses11310563donenesses
duenesses1039323_duenesses
dullnesses1135973dullnesses
dulnesses1037743dul_nesses
ediblenesses1545783ediblenesses
facilenesses1756703facilenesses
falsenesses1446743falsenesses
fellnesses1346083fellnesses
ficklenesses2144133ficklenesses
filminesses1636233filminesses
finesses111912333fi__nesses
firmnesses1535613firmnesses
fitnesses12219373fi_tnesses
fixednesses2244853fixednesses
freenesses1339863freenesses
fullnesses1336193fullnesses
fulnesses1239033ful_nesses
futilenesses1547173futilenesses
gamenesses1368983gamenesses
glegnesses1245073_glegnesses
glibnesses1344753glibnesses
gonenesses11310253gonenesses
halfnesses1636263halfnesses
highnesses1746083highnesses
hillinesses1458503hillinesses
hipnesses1436753hi_pnesses
holinesses13511483holinesses
hugenesses1437133hugenesses
icinesses11310053_icinesses
kindnesses1537213kindnesses
lamenesses12610563lamenesses
latenesses10413353latenesses
liminesses121310843liminesses
limpnesses14116653limpnesses
lionesses939423li_onesses
lithenesses1447303lithenesses
littlenesses1246073littlenesses
lonenesses10311343lonenesses
milkinesses1786793milkinesses
mirinesses121512303mirinesses
morenesses12811383morenesses
mutenesses1289933mutenesses
naivenesses1449083naivenesses
nighnesses1446463nighnesses
nimblenesses1655983nimblenesses
noblenesses1348053noblenesses
nudenesses1157853nudenesses
oldnesses1037703_oldnesses
onenesses9311823_onenesses
ovalnesses1346043oval_nesses
pinknesses1636583pinknesses
pipinesses1448593pipinesses
pixinesses1937363pixinesses
primenesses1548973primenesses
purenesses12810723purenesses
rarenesses10313093rarenesses
richnesses1537793richnesses
riminesses121211403riminesses
rudenesses1188863rudenesses
safenesses1349373safenesses
sagenesses11510823sagenesses
saltnesses10310163saltnesses
samenesses12410853samenesses
sanenesses10412693sanenesses
selfnesses1335893selfnesses
servilenesses1646263servilenesses
sicknesses1636753sicknesses
sidednesses1347103sidednesses
silentnesses1275443silentnesses
silkinesses1557903silkinesses
sillinesses1169843sillinesses
simplenesses1645613simplenesses
singlenesses1346093singlenesses
sizinesses1938643sizinesses
slimnesses1236423slimnesses
slynesses1235863_slynesses
snidenesses1248653snidenesses
sorenesses101313483sorenesses
stalenesses11311083stalenesses
stillnesses1146713stillnesses
surenesses101212203surenesses
sveltenesses1545213sveltenesses
tallnesses1037463tallnesses
tamenesses1259963tamenesses
tidinesses1139213tidinesses
tininesses10311153tininesses
tirednesses1247733tirednesses
titanesses1037233titanesses
tritenesses11710353tritenesses
truenesses1039313truenesses
tweenesses1345803tweenesses
uglinesses1138533uglinesses
vaguenesses1544813vaguenesses
vainnesses1337343vainnesses
validnesses1576023validnesses
vastnesses13128193vastnesses
vexednesses2244583vexednesses
victresses1544973victresses
villainesses1543503villainesses
vinasses1135703vi__nasses
visiblenesses1855293visiblenesses
vitalnesses1456243vitalnesses
vitesses1136333vi__tesses
vividnesses1844213vividnesses
voidnesses1436833voidnesses
votivenesses1847553votivenesses
waenesses1239773_waenesses
wellnesses1335783wellnesses
whitenesses1746633whitenesses
wholenesses1745803wholenesses
wildernesses1643623wildernesses
wirelesses1345333wirelesses
wirinesses131811513wirinesses
witnesses12219923wi_tnesses
woenesses1239133_woenesses

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 Filter1786911406030.310576422.6
2DLD Change Limit1406031628.11017337.0
3Display Results1621620.0802025.0
 (SQL Overall)1786911628.50021022.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.