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

112 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
selfnesses133589(None) 
deafnesses1436222deafnesses
fellnesses1346082fellnesses
halfnesses1636262halfnesses
saltnesses10310162saltnesses
selfness1135152selfne_s_s
sexinesses1739202sexinesses
slynesses1235862s_lynesses
solenesses10412702solenesses
wellnesses1335782wellnesses
baldnesses1337643baldnesses
beefinesses1675943beefinesses
boldnesses1337223boldnesses
calmnesses1436833calmnesses
coldnesses1338423coldnesses
deadnesses1238943deadnesses
dearnesses1139583dearnesses
deepnesses1366673deepnesses
deftnesses1436813deftnesses
demonesses1346703demonesses
dewinesses1438343dewinesses
dullnesses1135973dullnesses
dulnesses1037743dul_nesses
eerinesses10612573eerinesses
eldresses1045673_eldresses
fewnesses1534953fe_wnesses
feynesses1535223fe_ynesses
fullnesses1336193fullnesses
fulnesses1239033ful_nesses
gelidnesses1355983gelidnesses
glegnesses1245073glegnesses
halenesses13312033halenesses
holinesses13511483holinesses
idlenesses1138023idlenesses
illnesses937273_illnesses
keennesses1445323keennesses
leafinesses1437873leafinesses
leannesses10108343leannesses
lewdnesses1435393lewdnesses
malenesses12312203malenesses
mealinesses13310973mealinesses
meannesses12128163meannesses
meeknesses1644803meeknesses
meetnesses1237443meetnesses
mildnesses1397393mildnesses
nearnesses1039103nearnesses
neatnesses10310003neatnesses
newnesses1236123ne_wnesses
oilinesses101512433oilinesses
oldnesses1037703_oldnesses
palenesses12312653palenesses
pertnesses12310293pertnesses
realnesses10310843realnesses
rednesses10312303re_dnesses
sadnesses10310303s_adnesses
safenesses1349373safenesses
sagenesses11510823sagenesses
saltinesses11311443saltinesses
samenesses12410853samenesses
sanenesses10412693sanenesses
scalinesses1339313scalinesses
seaminesses13310753seaminesses
seedinesses1259203seedinesses
seemlinesses1445223seemlinesses
seeresses939053se_eresses
selectnesses1446103selectnesses
selenoses947463selen_oses
selfishnesses1844043selfishnesses
selfless1135013selfle_s_s
selflessly1642613selflessly
selflessness1444593selflessness
sheernesses1445843sheernesses
shynesses1535313s_hynesses
sicknesses1636753sicknesses
silkinesses1557903silkinesses
sillinesses1169843sillinesses
sizinesses1938643sizinesses
skewnesses1743763skewnesses
sleeknesses1545273sleeknesses
slimnesses1236423slimnesses
slownesses1344943slownesses
smallnesses1344963smallnesses
smugnesses1344563smugnesses
snubnesses1245403snubnesses
snugnesses1165423snugnesses
softnesses1337603softnesses
solidnesses1238103solidnesses
solonetses1043673solonetses
sorenesses101313483sorenesses
sournesses10310013sournesses
sprynesses1544973sprynesses
stalenesses11311083stalenesses
steelinesses1246723steelinesses
steepnesses1345913steepnesses
sternnesses1146633sternnesses
stiffnesses1743593stiffnesses
stillnesses1146713stillnesses
suchnesses1536653suchnesses
sulkinesses1557713sulkinesses
sultanesses1145543sultanesses
surenesses101212203surenesses
surlinesses11310043surlinesses
sveltenesses1545213sveltenesses
sweetnesses1445723sweetnesses
swiftnesses1744503swiftnesses
tallnesses1037463tallnesses
uglinesses1138533uglinesses
vilenesses13310213vilenesses
weaknesses1735463weaknesses
wetnesses12208213we_tnesses
wildnesses14157363wildnesses
wilinesses131911083wilinesses

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 Filter1786911406030.1731032896.0
2DLD Change Limit1406031125.70324654.2
3Display Results1121120.0601866.7
 (SQL Overall)1786911125.93630102.9
 
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.