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

235 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
humphed183542(None) 
humped144015241hump_ed
bumped134414002bump_ed
chumped17379492chump_ed
dumped123814492dump_ed
harumphed2041542harumphed
humbled153711812humbled
hummed144812672hum_med
humored1336722humored
humper134115882hump_er
humph155712212humph__
humphs16528162humph_s
humpier143110722humpier
hunched163710492hunched
hushed134416672hu_shed
hutched16359882hutched
jumped183511552jump_ed
lumped114216962lump_ed
mumped133813162mump_ed
pumped133915562pump_ed
rumpled123810012rumpled
thumped15387412thump_ed
tumped114216232tump_ed
umped104717272_ump_ed
whumped18335632whump_ed
amped104820513_amp_ed
bumbled144113043bumbled
bummed134211723bum_med
bumper123714343bump_er
bumpered1536003bumpered
bumph144911983bumph__
bumphs15467103bumph_s
bumpier13359203bumpier
bunched154312413bunched
burped116215503burp_ed
bushed124822383bu_shed
camped134720233camp_ed
champed174111483champ_ed
chomped17329773chomp_ed
chummed17396443chum_med
churched1934653churched
clumped143610663clump_ed
comped135919873comp_ed
compted143813523compted
crumped144311223crump_ed
crumpled15296873crumpled
cupped134413983cu_pped
cusped114312043cusp_ed
damped124315583damp_ed
dimpled132810303dimpled
dumbed124012083dum_bed
dumbhead17102743dumbhead
dummied13346723dummied
dumper114615213dump_er
dumpier12409653dumpier
duped95118323du_p_ed
dupped124411643du_pped
flumped15377713flump_ed
fumbled153710493fumbled
fumed116118823fum__ed
galumphed1841413galumphed
gimped123911473gimp_ed
graphed1498473graphed
grumped13337333grump_ed
gulped104610373gulp_ed
gummed123811663gum_med
gumshoed1542703gumshoed
gumweed1433943gumweed
gushed114816243gu_shed
hammed144116973ham_med
hamper134518653hamp_er
hampered16239933hampered
happed144820103h_apped
harped124418403harp_ed
harrumphed2151003harrumphed
hashed136021943h_ashed
hasped125014443hasp_ed
hatched163414463hatched
haunched1744813haunched
heaped124516903heap_ed
helped124714153help_ed
hemmed144211463hem_med
hempen1338963hemp_en
hempie132410563hempie_
hempier14319003hempier
hempseed1643613hempseed
hempweed1942803hempweed
hipped144317693h_ipped
hirpled13157143hirpled
hitched163312253hitched
homaged1497413homaged
homed115425423hom__ed
homered133212713homered
hooped125518183hoop_ed
hoped115628183h_op_ed
hophead16337923h_ophead
hopped144318113h_opped
hoppled15338083hoppled
hotched163610923hotched
huddled13349783huddled
hued86925853hu___ed
huffed163710153hu_ffed
hugged124113643hu_gged
hulked144611303hu_lked
hulled103920013hu_lled
hulloed11369793hulloed
humane112812173humane_
humaner12257663humaner
humate113214443humate_
humates122813193humates
humble133615053humble_
humbler143411943humbler
humbles143215803humbles
humid114213763hum__id
humidex2043283humidex
humified1745653humified
hummer133615273hum_mer
humoured1444363humoured
hump116228723hump___
humpers142713523humpers
humphing1935163humphing
humpiest1538963humpiest
humping153213073humping
humpless15226333humpless
humps126322803hump__s
humpy155115673hump__y
humuses1237593humuses
humvee1439203hum_vee
humvees1534683humvees
hunches153913463hunches
hundred1237143hundred
hunted104417013hu_nted
hurdled12379833hurdled
hurled104617453hu_rled
hurrahed1543463hurrahed
hurried113511043hurried
hurtled11339593hurtled
hushes124718593hu_shes
husked144212223hu_sked
hustled113210133hustled
hutches153613523hutches
hutted104616333hu_tted
huzzaed1943103huzzaed
huzzahed2341503huzzahed
hymned1535323hym_ned
hyped145313333h_yp_ed
hyphen1736393h_yphen
hypoed1547923h_ypoed
imped105117983_imp_ed
imphee13310353_imphee
impled113812513_impled
jumbled19379963jumbled
jumper173612373jump_er
jumpier18317943jumpier
lamped114017543lamp_ed
limped114817123limp_ed
lumpen104010663lump_en
lumper103816653lump_er
lumpier113410143lumpier
lunched133911823lunched
lurched13358033lurched
lushed104218723lu_shed
morphed1537133morphed
mulched15307763mulched
mumbled143010763mumbled
mummed104411553mum_med
mummied11327103mummied
mumper123513523mump_er
munched153411073munched
mushed124420843mu_shed
nudzhed2141823nudzhed
numbed114111443num_bed
nymphet1764323nymphet
oompahed1642903oompahed
ouched124316933ou_ched
ouphe104413263ou_phe_
ouphes113614633ou_phes
pimped134913483pimp_ed
pimpled14289193pimpled
plumped14318643plump_ed
pulped114612533pulp_ed
pumiced1435173pumiced
pumper124415553pump_er
punched153512173punched
pupped105013273pu_pped
purpled12299783purpled
pushed125017463pu_shed
quashed20207973quashed
quipped2175163quipped
ralphed1334363ralphed
ramped114617903ramp_ed
rhumbaed1672753rhumbaed
rimpled123311423rimpled
romped114513653romp_ed
ruched124314633ru_ched
rumbaed12287493rumbaed
rumbled124514593rumbled
rumored1046643rumored
rumple103913013rumple_
rumples113313133rumples
rushed104419863ru_shed
sampled123410793sampled
shlumped1643443shlump_ed
shushed14348493shu_shed
slumped123710153slump_ed
smushed13368233smushed
stumped124210153stump_ed
sughed113610203su_ghed
sulphid1346113sulphid
summed114014043sum_med
sumpter1138873sumpter
sumpweed1643723sumpweed
supped114415703su_pped
suppled1248463suppled
tamped114317043tamp_ed
temped113912893temp_ed
templed12278563templed
tempted12317283tempted
thumbed15336173thum_bed
thumper14356953thump_er
triumphed1741943triumphed
trumped12439713trump_ed
tumbled123412243tumbled
tupped114013233tu_pped
tushed104615893tu_shed
umpired1235783_umpired
unshed10313773_unshed
upheld12115563_u_pheld
upped103715163_u_pped
urped84615283_urp_ed
vamped144211013vamp_ed
whomped18345473whomp_ed
whupped18365413whu_pped
wimped144211513wimp_ed
wimpled15338823wimpled

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272357.09318895.7
3Display Results2352350.0932526.9
 (SQL Overall)1786912357.59223536.7
 
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.