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

515 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
whomps1645760(None) 
chomps155112221chomps
whomp155011321whomp_
whoops14487861whoops
whops135013931who_ps
whumps16427091whumps
champs154915682champs
chimps155713662chimps
chomp144815662chomp_
chops125019872cho_ps
chumps154313822chumps
clomps125212232clomps
comps115526052_comps
hemps126917332_hemps
homes106938822_homes
homos105921792_homos
hoops105621072_hoops
hops97942632_ho_ps
humps126322802_humps
pomps115316192_pomps
rhombs13336492rhombs
romps94617542_romps
shops104222902sho_ps
stomps105612832stomps
thorps113610892thorps
thumps13449352thumps
tromps104911702tromps
whams135515642wham_s
whaps135115162wh_aps
whaups14405752whaups
wheeps14439952wheeps
whelps14437842whelps
whims134515332whim_s
whips134917082wh_ips
wholes124616772wholes
whom127018182whom__
whomped18345472whomped
whomso1434132whomso
whoofs15457242whoofs
whoop134211442whoop_
whop125520922who_p_
whores125617102whores
whorls124410162whorls
whorts125111432whorts
whosis1237172whosis
whump154910042whump_
whups134210002wh_ups
wimps125213802w_imps
wombs125813342w_ombs
woops104917522w_oops
wops96634152w_o_ps
abamps1236253abamps
abomas101113583abomas
aholds10469483aholds
amps86230343__amps
aromas81018613aromas
atoms76817563atom_s
bhoots11459913bhoots
biomes103815253biomes
blimps12588153blimps
bloops106611343bloops
bombs115818823_bombs
booms95427123boom_s
bops86037983_bo_ps
bromes104719763bromes
bromos104213313bromos
bumps115921143_bumps
camps116330263_camps
champ145017963champ_
champy18509613champy
chams126028503cham_s
chaps125326063ch_aps
cheaps134613683cheaps
cheeps135312913cheeps
chemos13311723chemos
chimbs153910303chimbs
chimes134922573chimes
chimp145216473chimp_
chips125721253ch_ips
chirps135414003chirps
chocks174815313chocks
choirs114911883choirs
chokes154917383chokes
cholas114818003cholas
cholos114716853cholos
chomped17329773chomped
chomper163810073chomper
chompers17369593chompers
chooks155312793chooks
chop116024923cho_p_
choppy18376293choppy
chords125214633chords
chores114828023chores
chorus115014773chorus
choses115825133choses
chotts113610993chotts
chows135618203cho_ws
chromas142512693chromas
chromes142914933chromes
chromos142610273chromos
chump145315443chump_
chums125015833chum_s
chymes165912153chymes
clamps124515083clamps
clomp115615703clomp_
clops95924853clo_ps
clumps1215314643clumps
comas95833003_comas
combs116122963_combs
comes97246993_comes
comp106731253_comp_
compas125817063_compas
compo115318573_compo
compos124818803_compos
compt116328223_compt
compts125216653_compts
coombs124210193coombs
coops96229643_coops
cops86751373_co_ps
corps95927043_corps
coups95522473_coups
cramps125615563cramps
crimps124613453crimps
crops96125243cro_ps
croups104312553croups
crumps124514343crumps
damps105220413_damps
dhobis1236113dhobis
dholes104914793dholes
dhotis1038973dhotis
dhows125911223dho_ws
domes85735563_domes
doms76239573_dom_s
dooms85321343doom_s
dorps85419223_dorps
droops95110963droops
drops85719503dro_ps
dumps105220103_dumps
duomos936823duomos
flops105920143flo_ps
flumps135112503flumps
fops96532683_fo_ps
frumps13479783frumps
gamps105323713_gamps
ghosts10489273ghosts
ghouls1036043ghouls
gimps105915203_gimps
gloms85219783glom_s
glomus9468093glomus
glops85619553glo_ps
gnomes93812973gnomes
goops86620963_goops
gorps85316993_gorps
gramps114114273gramps
groups94210513groups
grumps114510573grumps
hames106138703_hames
hams96446133_ham_s
haps96443463_h_aps
harps105926873_harps
hasps105114643_hasps
heaps105223223_heaps
helps105219343_helps
hemes105031083_hemes
hemp115725623_hemp_
hempy154912763_hempy
hems95534943_hem_s
hims95230973_him_s
hips96433703_h_ips
hoars85925553_hoars
hobos106321353_hobos
hobs97038983_ho_bs
hocks144925493_hocks
hocus104715203_hocus
hods87239863_ho_ds
hoers85724923_hoers
hoes75755733_ho_es
hoggs107212463_hoggs
hogs87139663_ho_gs
hokes126231643_hokes
holds94623243_holds
holes84748653_holes
holks124720563_holks
holms105117803_holms
holp95727553_holp_
hols76946293_ho_ls
holts85627913_holts
home98042443_hom_e
homed115425423_homed
homer105828453_homer
homers114821983_homers
homey135924843_homey
homeys145012883_homeys
homie104622533_homie
homies114524733_homies
hommos13128503_hommos
homo96126473_hom_o
homy126623223_hom_y
hones88144493_hones
hongs95126203_hongs
honks125124523_honks
hons77350783_ho_ns
hoods95124083_hoods
hoofs115721043_hoofs
hooks125027123_hooks
hoop96129983_hoop_
hoots84830253_hoots
hop87554593_ho_p_
hope96639673_ho_pe
hopes105835643_hopes
hoppy154912353_hoppy
horas86333103_horas
horns86125333_horns
hos68364193_ho__s
hoses85443183_hoses
hosts85526703_hosts
hots78349333_ho_ts
hours85422393_hours
howes114730263_howes
howfs144814503_howfs
howks155016853_howks
howls116219223_howls
hows106345603_ho_ws
hoyas115016163_hoyas
hoys107733933_ho_ys
hump116228723_hump_
humph155712213_humph
humphs16528163_humphs
humpy155115673_humpy
hums96831423_hum_s
humus106215073_humus
hymns1337523_hymns
hyps125418413_h_yps
imps86221123__imps
jumps165116493_jumps
kemps135012523_kemps
khoums1594013khoums
knops115911813kno_ps
knosps12405013knosps
kops107031293_ko_ps
lamps95624833_lamps
limps95522673_limps
looms75124643loom_s
loops75723963_loops
lops66043353_lo_ps
loups75319623_loups
lumps95624983_lumps
mhos95517773mho__s
momes95134473_momes
moms86539483_mom_s
momus96116113_momus
mops85940133_mo_ps
mumps115619103_mumps
myomas1338303myomas
nomas74726413_nomas
nomes74933123_nomes
nomos75919743_nomos
noms65636403_nom_s
ohms95514033oh_m_s
oms56337513__om_s
oomph1236973_oomph
oomphs1344723_oomphs
oops65232673__oops
ops56641253__o_ps
phones114121213phones
phonos114114793phonos
phons105221143pho_ns
photos113316643photos
phots105418503pho_ts
pimps114616983_pimps
plops95920333plo_ps
plumps124612613plumps
pomes94833933_pomes
pomos95321583_pomos
pomp106225463_pomp_
poms87037743_pom_s
poops94422413_poops
pops86340953_po_ps
primps124711823primps
promos105116423promos
prompt12313013prompt
prompts1337473prompts
proms95426413prom_s
props95726883pro_ps
pumps115520603_pumps
ramps96224633_ramps
rhemes115913183rhemes
rhomb12399803rhom_b
rhombi13365203rhombi
rhombus14243893rhombus
rhos76319063rho__s
rhumbs13366773rhumbs
rhymes14419823rhymes
romp85926573_romp_
roms67038963_rom_s
rooms75324683room_s
roups75118903_roups
rumps95922293_rumps
samps96124673_samps
scamps125014173scamps
scoops105414363scoops
scops95820193sco_ps
shamas113717943shamas
shames114726223shames
shamos114216983shamos
shams105829413sham_s
shamus114112813shamus
sharps115516083sharps
shims104422553shim_s
ships105123773sh_ips
shleps114710333shleps
shlumps1434143shlumps
shmoes114612103shmoes
shnaps1148083shnaps
shoals94215793shoals
shoats94117083shoats
shocks154414583shocks
shoers94518333shoers
shoes85429663sho_es
shogis103810943shogis
shogs95319713sho_gs
shojis16348493shojis
shooks134515633shooks
shools94919013shools
shoos84226363sho_os
shoots94619363shoots
shop95629843sho_p_
shoppe133110323shoppe
shoppes143411403shoppes
shores94830413shores
shorls94516203shorls
shorts95321743shorts
shotes95321913shotes
shots84730853sho_ts
shotts93614703shotts
shouts94017723shouts
shoves124919423shoves
shows115324583sho_ws
shoyus1266003shoyus
shrimps14516753shrimps
simps94719763_simps
skimps14488043skimps
sloops85513623sloops
slops75026013slo_ps
slumps104313583slumps
snoops84314173snoops
soaps75120713_soaps
somas76030373_somas
soms66239373_som_s
sops65244563_so_ps
soups75322943_soups
stamps105614023stamps
stomas84816323stomas
stomp95616663stomp_
stoops85917893stoops
stops74827283sto_ps
stoups85313273stoups
stowps115710583stowps
stumps104912283stumps
sumps95023433_sumps
swamps135910263swamps
swoops114910923swoops
swops105913973swo_ps
tamps95524093_tamps
temps95417133_temps
themes115319253themes
thesps11448263thesps
tholes94919783tholes
tholos94213003tholos
thongs104611193thongs
thorns95314103thorns
thorp104414263thorp_
thorpe113610093thorpe
thorpes125010353thorpes
thous86017263tho_us
thrips11299013thrips
thumbs13377443thumbs
thump126211573thump_
thymes144810743thymes
thymus14324743thymus
tombs97818733_tombs
tomes76037383_tomes
toms68343493_tom_s
tops66248123_to_ps
tramps105114453tramps
tromp95815803tromp_
trompe105611263trompe
trompes114111623trompes
troops85712783troops
trumps104611883trumps
tumps95420793_tumps
umps85721943__umps
vamps125415483_vamps
wahoos122310593waho_os
wames106432803w_ames
wammus13426733wammus
wampus13499013w_ampus
wamus105514683w_amus
waps96642083w__aps
warms107726853warm_s
warmups1433813warmups
warps107126423w_arps
wasps106714693w_asps
wataps11248683wataps
weeps104120563w_eeps
whacks184610483whacks
whales124716943whales
wham125321693wham__
whammo16405193whammo
whammy19375293whammy
whamo135511263wham_o
whangs13439723whangs
whap125119643wh_ap_
wharfs1546373wharfs
whats117718993wh_ats
whaup13458883whaup_
wheals124512523wheals
wheats125013223wheats
wheels123811723wheels
wheens124610613wheens
wheep136214353wheep_
whelks16367323whelks
whelms14377573whelms
whelp136012093whelp_
whenas124610463whenas
whens114618763wh_ens
wheres125917443wheres
whets115019613wh_ets
whews145114493wh_ews
wheys145911553wh_eys
whids125413983wh_ids
whiffs1835083whiffs
whigs125612643wh_igs
whiles124418013whiles
whim126220533whim__
whimper17297723whimper
whimpers18276613whimpers
whimsy17375223whimsy
whines125120103whines
whins114922333wh_ins
whip125521843wh_ip_
whippy19385843whippy
whipt135317423wh_ipt
whirls124710533whirls
whirrs12408593whirrs
whirs115218093wh_irs
whisks16497353whisks
whists124613813whists
whites123919883whites
whits115923823wh_its
who95526773who___
whoa106615203who__a
whole114418093who_le
wholism1535883wholism
wholly15366573wholly
whomping19285943whomping
whoof144612693who_of
whooped16326933whooped
whoopee15287523whoopee
whoopees16294823whoopees
whooper15297153whooper
whoopers16286263whoopers
whoopie15295933whoopie
whoopies16267373whoopies
whoopla1542633whoopla
whooplas1644013whooplas
whoosh15244353whoosh
whoosis1335453whoosis
whopped18358003whopped
whopper17328503whopper
whoppers18297533whoppers
whore116018043who_re
whored135512123whored
whorish1636603whorish
whorl114612453who_rl
whort114623693who_rt
whose114914533who_se
whoso11509223who_so
whumped18335633whumped
whup125714163wh_up_
whys137011663wh__ys
wimp115521523w_imp_
wimpy155911923w_impy
wisps105214183w_isps
woads94818443w_oads
woes76440663w_o_es
wogs86531403w_o_gs
woks116224903w_o_ks
wolds95420183w_olds
wolfs116214163w_olfs
woman105818003w_oman
womans114613653w_omans
womb117022233w_om_b
womby155910093w_omby
women104619253w_omen
womyn13426363w_omyn
wonks124818343w_onks
wons74942043w_o_ns
wonts87621543w_onts
woods95723033w_oods
wooers93712443wooers
woofs114918003w_oofs
wools84421463w_ools
woos76238803w_o_os
wop87145133w_o_p_
words95425073w_ords
works125621903w_orks
worms105320763w_orms
worts88631183w_orts
wos66953533w_o__s
wots76342893w_o_ts
wows104633493w_o_ws
wraps105617153w_raps
wrongs10338933wrongs
zooms164415523zoom_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.390458182.1
2DLD Change Limit1127165155.15621861.1
3Display Results5155150.1563301.3
 (SQL Overall)1786915155.70231338.3
 
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.