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

221 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
stumpier125588(None) 
stumper113610091stump_er
bumpier13359202_bumpier
clumpier1435582clumpier
dumpier12409652_dumpier
frumpier1534172frumpier
glumpier1334872glumpier
grumpier1334802grumpier
humpier143110722_humpier
jumpier18317942_jumpier
lumpier113410142_lumpier
scummier1445082scummier
skimpier1634292skimpier
slummier1235472slummier
soupier93111752sou_pier
spumier1137902spum_ier
stamper113714402stamp_er
stemmier1245252stemmier
stomper114111232stomp_er
stripier1058862stripier
stubbier1235352stubbier
studier82510052stu_dier
studlier935472studlier
stuffier14336622stuffier
stumbler1235812stumbler
stumped124210152stump_ed
stumpers12318312stump_ers
stumpiest1335852stumpiest
stumping13289082stumping
stupider1133912stu_pider
sturdier9216962sturdier
sumpter1138872s_umpter
swampier1544592swampier
bumper123714343_bump_er
campier133313273_campier
chummier1734513chummier
clumsier1234733clumsier
costumier1343423costum_ier
crampier14288903crampier
crimpier14287323crimpier
crumbier1456363crumbier
crummier1435603crummier
crumplier1543783crumplier
cuppier1368323_cuppier
drumlier1134523drumlier
dumper114615213_dump_er
fumier11310903_fum_ier
gimpier12247943_gimpier
gulpier1046953_gulpier
gummier12349473_gummier
hempier14319003_hempier
humper134115883_hump_er
jumper173612373_jump_er
lumper103816653_lump_er
mumper123513523_mump_er
plumier113510043plum_ier
plummier1434123plummier
plumper13318773plump_er
pulpier1148623_pulpier
pumper124415553_pump_er
roupier9319493rou_pier
rummier11309563_rummier
rumplier1235303_rumplier
sampler113212013s_ampler
sappier113613113s_appier
saucier9810283sau_cier
scamper134613163scamp_er
scampies1439323scampies
schlumpier1941473schlumpier
scrimpier1554243scrimpier
scummer13398753scum_mer
scupper1367423scu_pper
scurfier13267053scurfier
scurvier13255883scurvier
scuzzier1842713scuzzier
seamier93114633seam_ier
seemlier1035193seemlier
seepier92912013s_eepier
shrimpier1643063shrimpier
shunpiker1841293shunpiker
simper103616293s_imp_er
simpler112910863s_impler
sirupier1034303sirupier
skunkier11174283skunkier
sleepier1036783sleepier
slimier93212013slim_ier
slimpsier1343023slimpsier
slimsier1085213slimsier
slippier1256533slippier
sloppier1255703sloppier
sludgier1034823sludgier
slumber113811003slum_ber
slummer113711203slum_mer
slumped123710153slump_ed
slumping13359973slumping
slushier1135983slushier
sluttier836453sluttier
smudgier1233753smudgier
smuttier1035213smuttier
snappier1266213snappier
snippier1255793snippier
snoopier10177273snoopier
snubbier1244993snubbier
snuffier14276943snuffier
soapier93411713s_oapier
soppier112711583s_oppier
spier75728033s___pier
spunkier14235813spunkier
spurrier10297693spurrier
staggier10167513staggier
stagier83513443st_agier
stalkier1257073stalkier
stammer116013343stam_mer
stamped124812813stamp_ed
stampeder14304343stampeder
stampers124211603stamp_ers
stamping133310963stamping
stapler93913633st_apler
starrier8279463starrier
steadier937313steadier
steamier1048303steamier
steelier839183steelier
steeper93812773steep_er
stemmer113210183stem_mer
stepper113010853st_epper
stickier14229763stickier
stillier868823stillier
stimied10310623stim_ied
stimies9316563stim_ies
stingier9279123stingier
stinkier12278543stinkier
stippler1235543stippler
stockier14217253stockier
stodgier1034223stodgier
stomped124110533stomp_ed
stompers123610043stomp_ers
stomping13309763stomping
stonier72013793st_onier
stooper93813193stoop_er
stoper84320103st_op_er
stopper113012603st_opper
stormier1036103stormier
strapper1258093strapper
strappier1345133strappier
strawier1137483strawier
striper94514793strip_er
stripper1247123stripper
stropper1247763stropper
stroppier1364453stroppier
strummer1234783strum_mer
strumpet1256033strump_et
stubblier1343203stubblier
stuccoer1252803stuccoer
studdie9195273studdie_
studdies10207073studdies
studied9268693stu_died
studiers9236623stu_diers
studies82413863stu_dies
stuffer13349793stu_ffer
stuiver10447083stu_iver
stumble1147553stumble_
stumbled1335623stumbled
stumblers1334383stumblers
stumbles1237493stumbles
stummed12348553stum_med
stumming13347673stumming
stump94616463stump___
stumpage1343303stumpage
stumpages1442803stumpages
stumps104912283stump__s
stumpy13458133stump__y
stunner7349193stu_nner
stupe75217753stu_p_e_
stupefier1442653stupefier
stupes84116953stu_p_es
stupid937593stu_pi_d
stupids1035273stu_pids
stupor836013stu_p_or
sturdied10215963sturdied
sturdies92110273sturdies
stutter72911463stu_tter
stymie1137623stym_ie_
stymied1335663stym_ied
stymies1239213stym_ies
suckier133613973s_uckier
sudsier868783s_udsier
sulkier113811963s_ulkier
summer104017713s_um_mer
sumpters1238023s_umpters
sunnier73412153s_unnier
super74924483s_u_p_er
supper104115433s_u_pper
suppler1148433s_uppler
supplier1246603s_upplier
surfier102613543s_urfier
surlier72915443s_urlier
suspire937803s_uspire
swamper14349313swamp_er
sweepier1355493sweepier
swimmier15174313swimmier
swoopier13175143swoopier
syrupier1343053syrupier
tamper104618513_tamp_er
temper103914093_temp_er
tempter11358213_tempter
thumper14356953thump_er
tippier113210543_tippier
trampier12318243trampier
tubbier11237743_tubbier
tuftier1096603_tuftier
tumbler113412823_tumbler
tummies113012033_tummies
tummler11266613_tummler
tumped114216233_tump_ed
tumping123114243_tumping
turfier10249793_turfier
typier1137333_t_ypier
umpire1047893__umpire
vampier14308233_vampier
wimpier14248053_wimpier
yummier14306843_yummier

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622216.51622431.2
3Display Results2212210.0762907.9
 (SQL Overall)1786912216.74826480.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.