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

124 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
limpnesses1411665(None) 
liminesses121310841liminesses
dampnesses1535602dampnesses
dimnesses1238212dim_nesses
hipnesses1436752hi_pnesses
impresses1338212_impresses
lamenesses12610562lamenesses
likenesses1449532likenesses
limpidnesses1743622limpidnesses
limpness1246702limpne_s_s
lionesses939422li_onesses
lippinesses1535512lippinesses
litenesses10513002litenesses
livenesses13411052livenesses
lumpinesses15107102lumpinesses
plumpnesses1753262plumpnesses
riminesses121211402riminesses
sliminesses1338092sliminesses
slimnesses1236422slim_nesses
wimpinesses1835632wimpinesses
airinesses102613603airinesses
aliennesses1145863aliennesses
alikenesses1547193alikenesses
alivenesses1448853alivenesses
biasnesses1236943biasnesses
bignesses1267953bi_gnesses
blindnesses1446183blindnesses
bumpinesses17126363bumpinesses
campinesses1737113campinesses
compresses1647773compresses
crispnesses1545943crispnesses
deepnesses1366673deepnesses
demonesses1346703demonesses
dippinesses1635243dippinesses
direnesses11311483direnesses
dumbnesses1584593dumbnesses
dumpinesses16126243dumpinesses
empresses1348163_empresses
filminesses1636233filminesses
finenesses13310713finenesses
finesses111912333fi__nesses
firmnesses1535613firmnesses
fitnesses12219373fi_tnesses
flimsinesses1743993flimsinesses
gamenesses1368983gamenesses
gaminesses13410453gaminesses
glibnesses1344753gli_bnesses
glumnesses1344733glum_nesses
griminesses14167553griminesses
grimnesses13106533grim_nesses
highnesses1746083highnesses
hippinesses1845493hippinesses
hominesses15510843hominesses
humpinesses18106233humpinesses
icinesses11310053_icinesses
illnesses937273_illnesses
impasses12257523_imp_asses
impreses1238093_impre_ses
impressed1446283_impressed
jumpinesses22125333jumpinesses
kindnesses1537213kindnesses
lacinesses12312103lacinesses
lamperses1345123lamp_erses
lanknesses1437503lanknesses
latenesses10413353latenesses
laxnesses1646633l_axnesses
lazinesses19310143lazinesses
leannesses10108343leannesses
lewdnesses1435393lewdnesses
licitnesses1346393licitnesses
lightnesses1546143lightnesses
limbernesses1643153limbernesses
liminess10510643limine_s_s
limonenes1144973limone_nes
lithenesses1447303lithenesses
lividnesses1545013lividnesses
loaminesses1358443loaminesses
loginesses11410313loginesses
lonenesses10311343lonenesses
longnesses1138503longnesses
loopinesses13116733loopinesses
lornnesses1037823lornnesses
lostnesses1049293lostnesses
loudnesses1138433loudnesses
lownesses1236983l_ownesses
luminesces1443953luminesces
lushnesses1337333lushnesses
mildnesses1397393mildnesses
mirinesses121512303mirinesses
nicenesses12310333nicenesses
nighnesses1446463nighnesses
nimbynesses1842053nimbynesses
nippinesses1545063nippinesses
numbnesses1474683numbnesses
oilinesses101512433oilinesses
pinknesses1636583pinknesses
pipinesses1448593pipinesses
pixinesses1937363pixinesses
plumbnesses1753073plumbnesses
primenesses1548973primenesses
primnesses1497803prim_nesses
richnesses1537793richnesses
rifenesses1339933rifenesses
ripenesses12310363ripenesses
samenesses12410853samenesses
sicknesses1636753sicknesses
simplenesses1645613simplenesses
sizinesses1938643sizinesses
skimpinesses2043183skimpinesses
slicknesses1745183slicknesses
tamenesses1259963tamenesses
tidinesses1139213tidinesses
timidnesses1445143timidnesses
tininesses10311153tininesses
titanesses1037233titanesses
trimnesses1287753trim_nesses
vilenesses13310213vilenesses
widenesses1438773widenesses
wildnesses14157363wildnesses
wilinesses131911083wilinesses
wirinesses131811513wirinesses
wisenesses13310803wisenesses
wispinesses1636263wispinesses
witnesses12219923wi_tnesses

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 Filter1786911406030.1701051123.5
2DLD Change Limit1406031247.33019181.9
3Display Results1241240.0631968.3
 (SQL Overall)1786911247.56323627.0
 
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.