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) 
liminesses121310851liminesses
dampnesses1535602dampnesses
dimnesses1238212dim_nesses
hipnesses1436752hi_pnesses
impresses1338212_impresses
lamenesses12610562lamenesses
likenesses1449532likenesses
limpidnesses1743622limpidnesses
limpness1246702limpne_s_s
lionesses939432li_onesses
lippinesses1535512lippinesses
litenesses10513022litenesses
livenesses13411072livenesses
lumpinesses15107112lumpinesses
plumpnesses1753262plumpnesses
riminesses121211412riminesses
sliminesses1338092sliminesses
slimnesses1236422slim_nesses
wimpinesses1835632wimpinesses
airinesses102613613airinesses
aliennesses1145863aliennesses
alikenesses1547203alikenesses
alivenesses1448873alivenesses
biasnesses1236963biasnesses
bignesses1267963bi_gnesses
blindnesses1446183blindnesses
bumpinesses17126373bumpinesses
campinesses1737113campinesses
compresses1647773compresses
crispnesses1545943crispnesses
deepnesses1366673deepnesses
demonesses1346703demonesses
dippinesses1635243dippinesses
direnesses11311483direnesses
dumbnesses1584603dumbnesses
dumpinesses16126253dumpinesses
empresses1348163_empresses
filminesses1636233filminesses
finenesses13310713finenesses
finesses111912343fi__nesses
firmnesses1535613firmnesses
fitnesses12219373fi_tnesses
flimsinesses1743993flimsinesses
gamenesses1368983gamenesses
gaminesses13410463gaminesses
glibnesses1344753gli_bnesses
glumnesses1344733glum_nesses
griminesses14167553griminesses
grimnesses13106533grim_nesses
highnesses1746083highnesses
hippinesses1845493hippinesses
hominesses15510863hominesses
humpinesses18106243humpinesses
icinesses11310073_icinesses
illnesses937283_illnesses
impasses12257523_imp_asses
impreses1238093_impre_ses
impressed1446283_impressed
jumpinesses22125343jumpinesses
kindnesses1537213kindnesses
lacinesses12312123lacinesses
lamperses1345123lamp_erses
lanknesses1437503lanknesses
latenesses10413363latenesses
laxnesses1646633l_axnesses
lazinesses19310153lazinesses
leannesses10108343leannesses
lewdnesses1435393lewdnesses
licitnesses1346413licitnesses
lightnesses1546143lightnesses
limbernesses1643153limbernesses
liminess10510643limine_s_s
limonenes1144983limone_nes
lithenesses1447313lithenesses
lividnesses1545023lividnesses
loaminesses1358453loaminesses
loginesses11410323loginesses
lonenesses10311343lonenesses
longnesses1138503longnesses
loopinesses13116733loopinesses
lornnesses1037823lornnesses
lostnesses1049303lostnesses
loudnesses1138433loudnesses
lownesses1236983l_ownesses
luminesces1443963luminesces
lushnesses1337343lushnesses
mildnesses1397393mildnesses
mirinesses121512313mirinesses
nicenesses12310353nicenesses
nighnesses1446463nighnesses
nimbynesses1842053nimbynesses
nippinesses1545063nippinesses
numbnesses1474693numbnesses
oilinesses101512443oilinesses
pinknesses1636583pinknesses
pipinesses1448603pipinesses
pixinesses1937373pixinesses
plumbnesses1753073plumbnesses
primenesses1548993primenesses
primnesses1497803prim_nesses
richnesses1537803richnesses
rifenesses1339943rifenesses
ripenesses12310373ripenesses
samenesses12410853samenesses
sicknesses1636763sicknesses
simplenesses1645623simplenesses
sizinesses1938653sizinesses
skimpinesses2043183skimpinesses
slicknesses1745193slicknesses
tamenesses1259973tamenesses
tidinesses1139223tidinesses
timidnesses1445143timidnesses
tininesses10311163tininesses
titanesses1037253titanesses
trimnesses1287753trim_nesses
vilenesses13310223vilenesses
widenesses1438773widenesses
wildnesses14157363wildnesses
wilinesses131911093wilinesses
wirinesses131811523wirinesses
wisenesses13310823wisenesses
wispinesses1636273wispinesses
witnesses12219923wi_tnesses

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.1561145455.1
2DLD Change Limit1406031246.12622951.8
3Display Results1241240.0631968.3
 (SQL Overall)1786911246.34528162.5
 
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.