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

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

157 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
humps12632280(None) 
bumps115921141bumps
chumps154313821chumps
dumps105220101dumps
hemps126917331hemps
hump116228721hump_
humph155712211humph
humphs16528161humphs
humpy155115671humpy
hums96831421hum_s
humus106215071humus
jumps165116491jumps
lumps95624981lumps
mumps115619101mumps
pumps115520601pumps
rumps95922291rumps
sumps95023431sumps
thumps13449351thumps
tumps95420791tumps
umps85721941_umps
whumps16427091whumps
amps86230342_amps
bumfs125414052bumfs
bump106228242bump_
bumph144911982bumph
bumphs15467102bumphs
bumpy144715052bumpy
bums85934592bum_s
burps94220172burps
camps116330262camps
champs154915682champs
chimps155713662chimps
chomps155112222chomps
chump145315442chump_
chums125015832chum_s
clumps1215314642clumps
comps115526052comps
crumps124514342crumps
cups85430822cu_ps
cusps94913672cusps
damps105220412damps
dumas85420432dumas
dumbs105915752dumbs
dump95927092dump_
dumpy135414752dumpy
dups75929512du_ps
flumps135112502flumps
frumps13479782frumps
fumes105224702fumes
gamps105323712gamps
gimps105915202gimps
grumps114510572grumps
gulps84715072gulps
gums75030942gum_s
hames106138702hames
hams96446132ham_s
haps96443462h_aps
harps105926872harps
hasps105114642hasps
heaps105223222heaps
helps105219342helps
hemes105031082hemes
hemp115725622hemp_
hempy154912762hempy
hems95534942hem_s
hims95230972him_s
hips96433702h_ips
homes106938812homes
homos105921782homos
hoops105621072hoops
hops97942632h_ops
hubs96027142hu_bs
hucks144322172hucks
hues75235232hu_es
huffs144514742huffs
hugs86129752hu_gs
hulas84920882hulas
hulks125715482hulks
hulls84923562hulls
hum85542932hum__
human102716032human
humans112312432humans
humic124113242humic
humid114213762humid
hummus1336242hummus
humor101110512humor
humors11129632humors
humped144015242humped
humper134115882humper
humpers142713522humpers
hunks125321452hunks
huns76136932hu_ns
hunts86826172hunts
hup86437812hu_p_
hurds95219072hurds
hurls86522712hurls
hurts86922822hurts
husks125015452husks
huts76737442hu_ts
hymns1337522hymns
hyps125418412h_yps
imps86221122_imps
jump156621722jump_
jumpy195712812jumpy
kemps135012522kemps
kumys1435932kumys
lamps95624832lamps
limps95522672limps
lumas75622912lumas
lump86531702lump_
lumpy126615912lumpy
lums65734242lum_s
mumms85513152mumms
mump105425722mump_
mums85732772mum_s
mumus95517282mumus
numbs94913092numbs
pimps114616982pimps
plumps124612612plumps
pomps115316192pomps
pulps95116482pulps
pumas95121562pumas
pump105726852pump_
pups86032232pu_ps
quips164713372quips
ramps96224632ramps
rhumbs13366772rhumbs
romps94617542romps
rump86729082rump_
rumpus10458892rumpus
rums64833472rum_s
samps96124672samps
shlumps1434142shlumps
simps94719762simps
slumps104313582slumps
stumps104912282stumps
sumos75720092sumos
sump86331532sump_
sums65837582sum_s
sups64834432su_ps
tamps95524082tamps
temps95417132temps
thumbs13377442thumbs
thump126211572thump_
trumps104611882trumps
tump85927032tump_
tups65628762tu_ps
turps74918732turps
ump76130442_ump_
ups55629052_u_ps
urps66920472_urps
vamps125415482vamps
whomps16457602whomps
whump154910042whump_
whups134210002whu_ps
wimps125213802wimps
yups96121602yu_ps

Search took 2 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 Filter178691538000.326548131.9
2DLD Change Limit538001571.48636204.6
3Display Results1571570.0463413.0
 (SQL Overall)1786911571.85896173.8
 
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.