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 “lumpishnesses” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
lumpishnesses204347(None) 
blimpishnesses2382142blimpishnesses
impishnesses1944292_impishnesses
lumpinesses15107112lumpi__nesses
lumpishness1843152lumpishne_s_s
uppishnesses1943602_uppishnesses
wimpishnesses2343582wimpishnesses
apishnesses1646373__apishnesses
bluishnesses1765263blu__ishnesses
bullishnesses1844043bullishnesses
bumpinesses17126373bumpi__nesses
cultishnesses1844563cultishnesses
dumpinesses16126253dumpi__nesses
foppishnesses2343393foppishnesses
humpinesses18106243humpi__nesses
jumpinesses22125343jumpi__nesses
lavishnesses1844773l_avishnesses
limpidnesses1743623limpi_dnesses
loutishnesses1644993loutishnesses
lushnesses1337343lu___shnesses
mulishnesses1755093mu_lishnesses
puckishnesses2443333puckishnesses
ruttishnesses1644043ruttishnesses
sluggishnesses1852143sluggishnesses
sluttishnesses1652683sluttishnesses
waspishnesses2043283waspishnesses
bearishnesses1844844bearishnesses
blimpishness2172074blimpishne_s_s
bookishnesses2263684bookishnesses
boorishnesses1864314boorishnesses
boyishnesses2044034_boyishnesses
brutishnesses1844094brutishnesses
caddishnesses2043374caddishnesses
campinesses1737114campi__nesses
churlishnesses2252544churlishnesses
clannishnesses1952984clannishnesses
cliquishnesses2852114cliquishnesses
cloddishnesses2152624cloddishnesses
clownishnesses2262274clownishnesses
clumsinesses1644774clum__sinesses
coltishnesses1845224coltishnesses
doggishnesses19143684doggishnesses
dollishnesses1744374dollishnesses
doltishnesses1744614doltishnesses
donnishnesses1784114donnishnesses
dovishnesses1944464_dovishnesses
faddishnesses2143244faddishnesses
flushnesses1745384flu___shnesses
folkishnesses2343924folkishnesses
foolishnesses1944464foolishnesses
garishnesses1645884_garishnesses
gawkishnesses2443034gawkishnesses
girlishnesses1744034girlishnesses
grumpinesses1743664grumpi__nesses
gumminesses1634934gummi__nesses
hawkishnesses2643254hawkishnesses
hellishnesses1974354hellishnesses
hoggishnesses21143654hoggishnesses
humidnesses1744584hum_i_dnesses
impishness1744124_impishne_s_s
liminesses121310854lim_i__nesses
limpnesses14116654limp___nesses
lippinesses1535514lippi__nesses
liverishnesses2063024liverishnesses
loopinesses13116734loopi__nesses
lucidnesses1445244lu_ci_dnesses
luckinesses1746654lucki__nesses
luminesces1443964lum_i__nesces
lumpiness1336484lumpi__ne_s_s
luridnesses1246724lu_ri_dnesses
lustinesses11910424lusti__nesses
mannishnesses1873964mannishnesses
mawkishnesses2543134mawkishnesses
modishnesses1844734_modishnesses
moistnesses1347154__moistnesses
oafishnesses1844774_oafishnesses
offishnesses2143814_offishnesses
owlishnesses1844644_owlishnesses
peevishnesses2143474peevishnesses
pettishnesses1844384pettishnesses
piggishnesses2043284piggishnesses
pinkishnesses2243984pinkishnesses
plumpnesses1753264plump___nesses
plushnesses1645584plu___shnesses
poshnesses1537464___poshnesses
prudishnesses1943674prudishnesses
pulpinesses1536004pulpi__nesses
qualmishnesses2852084qualmishnesses
raffishnesses2243224raffishnesses
rakishnesses1944994_rakishnesses
reddishnesses1873584reddishnesses
remissnesses1344954rem_issnesses
roguishnesses1763974roguishnesses
selfishnesses1844044selfishnesses
sheepishnesses2153014sheepishnesses
sickishnesses2143664sickishnesses
slavishnesses1843684slavishnesses
snappishnesses2052264snappishnesses
sottishnesses1544454sottishnesses
squarishnesses2552444squarishnesses
stylishnesses1843404stylishnesses
supinenesses1446014su_pinenesses
swinishnesses1843654swinishnesses
tumidnesses1444614tum_i_dnesses
uppishness1743494_uppishne_s_s
uppitinesses16103704_uppitinesses
uppitynesses19101934_uppitynesses
voguishnesses2063494voguishnesses
waggishnesses2143284waggishnesses
wimpinesses1835634wimpi__nesses
wimpishness2143214wimpishne_s_s
wolfishnesses2243734wolfishnesses
womanishnesses2252824womanishnesses
yumminesses1843874yummi__nesses

Search took 5 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 Filter178691950240.360496363.9
2DLD Change Limit950241144.32621965.8
3Display Results1141140.0761500.0
 (SQL Overall)1786911144.76237524.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.