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

191 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
lumpish1412738(None) 
clumpish17164891clumpish
dumpish15116111dumpish
lumpfish1843051lumpfish
plumpish17164731plumpish
blimpish1743722blimpish
dampish1567662dampish
frumpish1843502frumpish
grumpish1643762grumpish
impish13499192_impish
lumpier113410142lumpier
lumpiest1239252lumpiest
lumpily1476562lumpily
lumping123314642lumping
lumpishly1943052lumpishly
lumps95624982lump_s_
rompish1436692rompish
uppish1336632_uppish
vampish1766282vampish
wampish1777292wampish
wimpish1765692wimpish
apish105116633__apish
aspish114810333_aspish
blemish1436603blem_ish
bluefish1645143bluefish
blueish1236483blu_eish
bluish1159243blu__ish
buckish18237883buckish
bullish12511193bullish
bumph144911983bump__h
bumphs15467103bumphs_
bumpier13359203bumpier
bumpiest1437873bumpiest
bumpily1665653bumpily
bumping143812493bumping
bumps115921143bump_s_
burnish1238623burnish
clubbish1743813clubbish
clumpier1435583clumpier
clumpiest1535343clumpiest
clumping15319883clumping
clumps1215314643clump_s_
cubbish1635803cubbish
cuish10313173cu__ish
cultish12139113cultish
currish1238353currish
cuspis105010703cuspis_
drumfish1743503drumfish
dudish1148313du_dish
dullish1148743dullish
dumpier12409653dumpier
dumpiest1338743dumpiest
dumpily1566233dumpily
dumping133712913dumping
dumps105220103dump_s_
duncish1335793duncish
duskish1535183duskish
famish14311843fam_ish
flemish1536373flem_ish
fluish1239333flu__ish
flumping16287583flumping
flumps135112503flump_s_
foppish1735103foppish
furbish1536443furbish
furnish1337383furnish
glumpier1334873glumpier
glumpiest1434943glumpiest
glumpily1643593glumpily
hippish1736183hippish
huffish1935713huffish
humph155712213hump__h
humphs16528163humphs_
humpier143110723humpier
humpiest1538963humpiest
humping153213073humping
humps126322803hump_s_
hunnish1336163hunnish
impis96213853_impis_
jumpier18317943jumpier
jumpiest1936863jumpiest
jumpily2174983jumpily
jumping19319803jumping
jumps165116493jump_s_
kumiss1235923kum_iss
laddish12299723laddish
ladyish14287823ladyish
lampas106615953lampas_
lamping123116003lamping
lampion11278303lampion
lamps95624833lamp_s_
lapis76223153l_apis_
largish1138603largish
larkish1439083larkish
latish92416173l_atish
lavish124112983l_avish
lazyish22265853lazyish
leftish13197253leftish
lemonish1347323lemonish
lempira1144193lempira
limpas105513083limpas_
limpest113712313limpest
limpid11389753limpi_d
limping124614113limping
limps95522673limp_s_
limpsy13516843limp_sy
loggish12258723loggish
longish11229093longish
loudish1137983loudish
loutish1039963loutish
lowish12310533l_owish
lumas75622913lum_as_
lumens85013973lumens_
lumina84613543lum_ina
luminism1247353luminism
luminist10410563luminist
lump86531703lump___
lumped114216963lump_ed
lumpen104010663lump_en
lumpens11298263lumpens
lumper103816653lump_er
lumpers113514483lumpers
lumpfishes2042873lumpfishes
lumpiness1336483lumpiness
lumpy126615913lump__y
lums65734243lum__s_
lungfish1543963lungfish
lungis77113023lungis_
lupin75215843lu_pi_n
lupine84013533lu_pine
lupins84514463lu_pins
lupus74512523lu_pus_
lush75327693lu___sh
lutfisk1443583lutfisk
lutist64317553lu_tist
lymph1547043lymp__h
lymphs1635053lymphs_
mopish134311593_mopish
mudfish1646263mudfish
mulish11311903mu_lish
mumping143411633mumping
mumps115619103mump_s_
numbfish1842603numbfish
nunnish1035933nunnish
outfish132210573outfish
outpush1245493outpush
outwish13289853outwish
pish96127913___pish
plumbism1643813plumbism
plumpest14236353plumpest
plumping15277633plumping
plumps124612613plump_s_
popish133812113_popish
publish1447913publish
puckish18237213puckish
puggish14265993puggish
pumping144213553pumping
pumps115520603pump_s_
punish111411503pu_nish
punkish16257693punkish
pupfish1735533pupfish
puppyish1742453puppyish
purplish1554933purplish
quippish2442633quippish
rammish1437563rammish
raspish1298103raspish
rubbish1436303rubbish
rumps95922293rump_s_
rumpus10458893rumpus_
runtish1048693runtish
rupiah1146213ru_piah
ruttish1048303ruttish
scampish1744893scampish
sluggish1344773sluggish
slumism1136513slum_ism
slumping13359973slumping
slumps104313583slump_s_
sluttish1145443sluttish
sumoist9311613sumoist
sumps95023433sump_s_
sunfish1338883sunfish
swampish1844173swampish
trampish1535653trampish
tumping123114243tumping
tumps95420793tump_s_
tundish1137283tundish
umping114815333_umping
umpire1047893_umpire
umps85721943_ump_s_
unwish1239093_unwish
waspish1586923waspish
wispish1575643wispish

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271916.34321129.9
3Display Results1911910.0633031.7
 (SQL Overall)1786911916.79626293.6
 
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.