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

357 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
humphs1652816(None) 
bumphs15467101bumphs
humph155712211humph_
humps126322801hump_s
bumph144911982bumph_
bumps115921142bump_s
chumps154313822chump_s
dumps105220102dump_s
harumphs1841922harumphs
hemps126917332hemp_s
humans112312432humans
hummus1336242hummus
humors11129632humors
hump116228722hump__
humped144015242humped
humper134115882humper
humpers142713522humpers
humphed1835422humphed
humpy155115672hump_y
hums96831422hum__s
humus106215072hum_us
huppahs1743332huppahs
jumps165116492jump_s
lumps95624982lump_s
lymphs1635052lymphs
mumps115619102mump_s
nymphs1633502nymphs
oomphs1344722oomphs
ouphs104311272ou_phs
pumps115520602pump_s
rumps95922292rump_s
rumpus10458892rumpus
sumps95023432sump_s
thumps13449352thump_s
tumps95420792tump_s
umps85721942_ump_s
whumps16427092whump_s
alephs1136533alephs
almahs118611613almahs
almehs11619493almehs
amahs107819063_amahs
amps86230343_amp_s
bimahs13508303bimahs
bumfs125414053bum_fs
bump106228243bump__
bumped134414003bumped
bumper123714343bumper
bumpers133912053bumpers
bumpy144715053bump_y
bums85934593bum__s
burghs12519923burghs
burps94220173burp_s
campos125217953campos
camps116330263camp_s
campus125213923campus
caphs124515373_caphs
champs154915683champ_s
chimps155713663chimp_s
chomps155112223chomp_s
chump145315443chump__
chumped17379493chumped
chums125015833chum__s
chuppahs2042073chuppahs
chuppas1644123chuppas
clumps1215314643clump_s
compas125817063compas
compos124818803compos
comps115526053comp_s
compts125216653compts
crumps124514343crump_s
cumins103314933cumins
cuppas12458593cuppas
cups85430823cu_p_s
cuspis105010703cuspis
cusps94913673cusp_s
damps105220413damp_s
dumas85420433dum_as
dumbos114111083dumbos
dumbs105915753dum_bs
dump95927093dump__
dumped123814493dumped
dumper114615213dumper
dumpers123412663dumpers
dumpish15116113dumpish
dumpy135414753dump_y
dupes86425933du_pes
dups75929513du_p_s
flumps135112503flump_s
frumps13479783frump_s
fumers113613383fumers
fumes105224703fum_es
fumets114311813fumets
galumphs1642023galumphs
gamps105323713gamp_s
gimps105915203gimp_s
glyphs1534303glyphs
graphs124510153graphs
grumphy18443623grumphy
grumps114510573grump_s
guimpes1245073guimpes
gulps84715073gulp_s
gumbos114610873gumbos
gummas114810513gummas
gums75030943gum__s
hahs108333363h__ahs
hamals114816813hamals
hames106138703ham_es
hamper134518653hamper
hampers143616943hampers
hams96446133ham__s
hamzahs24134373hamzahs
hamzas20119013hamzas
haps96443463h_ap_s
harps105926863harp_s
harrumphs1951253harrumphs
harumph1742933harumph_
hasps105114643hasp_s
haughs13408563haughs
heaps105223223heap_s
heaths126316383heaths
hehs106723963h__ehs
helps105219343help_s
hemes105031083hem_es
hemins113417563hemins
hemp115725623hemp__
hempen1338963hempen
hempie132410563hempie
hempy154912763hemp_y
hems95534943hem__s
herpes115517323herpes
heths116317783h_eths
heuchs14447923heuchs
heughs13516903heughs
highs125412523h_ighs
hims95230973him__s
hippos13408433hippos
hips96433703h_ip_s
homers114821973homers
homes106938813hom_es
homeys145012873homeys
homies114524723homies
hommos13128503hommos
homos105921783hom_os
hoops105621073hoop_s
hopes105835643h_opes
hops97942633h_op_s
horahs126313873horahs
houdahs1434243houdahs
hubris11218973hubris
hubs96027143hu__bs
hucks144322173hu_cks
hues75235233hu__es
huffs144514743hu_ffs
hugs86129753hu__gs
huh96432013hu__h_
huipil1143773huipil
huipils1243533huipils
hulas84920883hu_las
hulks125715483hu_lks
hullos94916293hullos
hulls84923563hu_lls
hum85542933hum___
human102716033hum_an
humane112812173humane
humate113214443humate
humates122813193humates
humble133615053humble
humbles143215803humbles
humbly164010523humbly
humbug1434803humbug
humbugs1534243humbugs
humeri1138523humeri
humerus1236913humerus
humic124113243hum_ic
humid114213763hum_id
hummed144812673hummed
hummer133615273hummer
hummers143813063hummers
humor101110513hum_or
humour11116753humour
humours1286413humours
humphing1935163humphing
humpier143110723humpier
humpiest1538963humpiest
humping153213073humping
humpless15226333humpless
humuses1237593humuses
humvee1439203humvee
humvees1534683humvees
hunch136416213hunch_
hunches153913463hunches
hunh106323733hu_nh_
hunks125321453hu_nks
huns76136933hu__ns
hunts86826173hu_nts
hup86437813hu_p__
huppah1644183huppah
hurds95219073hu_rds
hurls86522713hu_rls
hurrahs13336773hurrahs
hursts97213093hursts
hurts86922823hu_rts
hush105224113hu_sh_
hushes124718593hushes
husks125015453hu_sks
hutch135414093hutch_
hutches153613523hutches
huts76737443hu__ts
hutzpahs2541443hutzpahs
hutzpas2142693hutzpas
huzzahs2143083huzzahs
huzzas1735863huzzas
hymens1437993hymens
hymns1337523hym_ns
hypes135818673h_ypes
hypha1637383h_ypha
hypos1312014743h_ypos
hyps125418413h_yp_s
impis96213833_impis
imps86221113_imp_s
jumbos17379123jumbos
jump156621723jump__
jumped183511553jumped
jumper173612373jumper
jumpers18399843jumpers
jumpy195712813jump_y
jupes145218553ju_pes
kaphs144911503_kaphs
kemps135012523kemp_s
khaphs18394323khaphs
kophs145010933_kophs
kumiss1235923kumiss
kumys1435933kum_ys
lampas106615953lampas
lamps95624833lamp_s
limpas105513083limpas
limps95522673limp_s
lumas75622913lum_as
lumens85013973lumens
lump86531703lump__
lumped114216963lumped
lumpen104010663lumpen
lumpens11298263lumpens
lumper103816653lumper
lumpers113514483lumpers
lumpish14127383lumpish
lumpy126615913lump_y
lums65734243lum__s
lupus74512523lu_pus
lymph1547043lymph_
morphs13149433morphs
mumms85513153mum_ms
mump105425723mump__
mumped133813163mumped
mumper123513523mumper
mumpers133311363mumpers
mums85732773mum__s
mumus95517283mum_us
murphy1654343murphy
musths11589483musths
numbs94913093num_bs
nymph1555213nymph_
nympha1643573nympha
nympho1643583nympho
nymphos1744083nymphos
oompahs1434263oompahs
oomph1236973oomph_
ouph95618373ou_ph_
ouphe104413263ou_phe
ouphes113614633ou_phes
pampas124913993pampas
pimps114616983pimp_s
plumps124612613plump_s
pomps115316193pomp_s
pujahs18404943pujahs
pulps95116483pulp_s
pumas95121563pum_as
pump105726853pump__
pumped133915563pumped
pumper124415553pumper
pumpers133113673pumpers
pupas95219283pu_pas
pups86032233pu_p_s
pupus94614043pu_pus
qophs19507813_qophs
quips164713373quip_s
quipus17458003quipus
ralphs1135373ralphs
ramps96224633ramp_s
rhumbas14305163rhumbas
rhumbs13366773rhum_bs
romps94617543romp_s
rumbas102512013rumbas
rumens83611813rumens
rumors81110393rumors
rump86729083rump__
rumple103913013rumple
rumples113313133rumples
rumply13348573rumply
rums64833473rum__s
ruths85714643ru_ths
samps96124673samp_s
shlumps1434143shlump_s
simps94719763simp_s
slumps104313583slump_s
sophs104916023_sophs
staphs114411033staphs
stumps104912283stump_s
subahs114512383subahs
sughs95313323su_ghs
sulpha1135403sulpha
sulphas1236243sulphas
sumachs14457353sumachs
sumacs105512103sumacs
summas104313163summas
sumos75720093sum_os
sump86331533sump__
sums65837583sum__s
supes75628303su_pes
sups64834433su_p_s
surahs94515543surahs
sylphs1435543sylphs
syphs13519453_syphs
tamps95524083tamp_s
tempehs14325153tempehs
tempos103812293tempos
temps95417133temp_s
tempts10439453tempts
thumbs13377443thum_bs
thump126211573thump__
thumped15387413thumped
thumper14356953thumper
thumpers15365713thumpers
tophs105220053_tophs
triumphs1542513triumphs
trumps104611883trump_s
tumors8810603tumors
tump85927033tump__
tumped114216233tumped
tups65628763tu_p_s
turps74918733turp_s
ughs85410973_u_ghs
umbos94613063_umbos
ump76130443_ump__
umped104717273_umped
upas68322383_u_pas
ups55629053_u_p_s
urps66920473_urp_s
vamps125415483vamp_s
vughs12678743vu_ghs
wampus13499013wampus
whomps16457603whomp_s
whump154910043whump__
whumped18335633whumped
whups134210003whu_p_s
wimps125213803wimp_s
yups96121603yu_p_s

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163575.00022543.2
3Display Results3573570.1103245.5
 (SQL Overall)1786913575.25034036.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.