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

500 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
wampus1349901(None) 
campus125213921campus
wammus13426731wammus
wampum15406051wampum
wampums16314211wampums
wamus105514681wam_us
amps86230342_amp_s
ampul91110852_ampul
ampuls1098892_ampuls
amus65529612_am_us
awmous1157712awmous
campos125217952campos
camps116330262camp_s
carpus105514302carpus
damps105220412damp_s
famous11412392famous
gamps105323712gamp_s
grampus12356312grampus
iambus10468902iambus
lampas106615952lampas
lamps95624832lamp_s
palpus104210282palpus
pampas124913992pampas
pappus9408372pappus
ramous8417112ramous
ramps96224632ramp_s
ramus76418282ram_us
rumpus10458892rumpus
samps96124672samp_s
swamps135910262swamp_s
tamps95524082tamp_s
vamps125415482vamp_s
walrus956432walrus
wames106432802wam_es
wampish1777292wampish
wampuses1534112wampuses
waps96642082wa_p_s
warmups1433812warmups
warps107126422warp_s
wasps106714692wasp_s
wimps125213802wimp_s
abamps1236253abamp_s
agamous1037943agamous
alps65529243_alp_s
amahs107819063_amahs
amas67746293_am_as
amass77119683_amass
ambos95321253_ambos
ambush1336113_ambush
amens75624843_amens
amias75831473_amias
amicus103810003_amicus
amids85627513_amids
amies76837693_amies
amins75534323_amins
amirs75924923_amirs
amis66445323_am_is
amiss75823073_amiss
ammos94815823_ammos
amoks11413553_amoks
amour75014853_amour
amours83512663_amours
amp77541023_amp__
amped104820513_amped
ample94720303_ample
amply125012913_amply
ampule10710613_ampule
ampules1189433_ampules
amu58237323_am_u_
amuse75920833_am_use
amyls104512693_amyls
ankus91410683_ankus
anus47131113_a_nus
apes66047433_a_pes
apos65433823_a_pos
apps86319693_a_pps
arcus76918863_arcus
argus66716543_argus
ascus75013583_ascus
aspis74618143_aspis
asps65622093_asp_s
babus95620333ba_bus
bams87044453bam__s
baps86040843ba_p_s
bayous11411153bayous
bumphs15467103bumphs
bumps115921143bump_s
cactus104912233cactus
callus85317073callus
camas96333523cam_as
camass104114183camass
camels105217083camels
cameos105818003cameos
cames97047313cam_es
camos95927613cam_os
camp106336453camp__
camped134720233camped
camper124722213camper
campers134220293campers
campi116217783camp_i
campo115219763camp_o
campout13412853campout
campouts1436823campouts
campused1535253campused
campuses1437773campuses
campy145116183camp_y
cams87047283cam__s
cantus85117763cantus
capes95441923ca_pes
caphs124515373ca_phs
capos94826073ca_pos
caps87147893ca_p_s
caput9823983ca_put
carps96932253carp_s
casus76419253ca_sus
caucus1039613caucus
champs154915683champ_s
clamps124515083clamp_s
comous10816503comous
compas125817063compas
compos124818803compos
comps115526053comp_s
compts125216653compts
corpus106015293corpus
coypus13389303coypus
cramps125615563cramp_s
cymous1388403cymous
damans94715983damans
damars93814993damars
dames85435853dam_es
damns84916923dam_ns
damp96228843damp__
damped124315583damped
dampen114310593dampen
dampens12348563dampens
damper114117753damper
dampers123915693dampers
dampest12411043dampest
dampish1567663dampish
damply14337893damply
dams77444373dam__s
daps77239163da_p_s
dumps105220103dump_s
emeus76913333_emeus
emus66821683_em_us
fames105735923fam_es
famulus1235043famulus
favus114311733fa_vus
gallus74313203gallus
gamas85431363gam_as
gamays126310913gamays
gambas115817513gambas
gambes116318313gambes
gambs105721123gam_bs
gamers94420833gamers
games86238553gam_es
gamins94420043gamins
gammas115714693gammas
gamp98833213gamp__
gams76648883gam__s
gamut8322983gam_ut
gamuts958783gamuts
gapes86030823ga_pes
gaps76042973ga_p_s
gasps85415483gasp_s
gawps115911013gawp_s
gimps105915203gimp_s
grampas12399253grampas
gramps114114273gramp_s
habus106317143ha_bus
haikus13538293haikus
hakus125114113ha_kus
hamals114816823hamals
hamaul114210873hamaul
hamauls12387813hamauls
hames106138703ham_es
hamper134518653hamper
hampers143616953hampers
hams96446133ham__s
hamulus1235323hamulus
hamzas20119013hamzas
haps96443463ha_p_s
harps105926873harp_s
hasps105114643hasp_s
hemps126917333hemp_s
hummus1336243hummus
humphs16528163humphs
humps126322803hump_s
humus106215073hum_us
iambs95815063iam_bs
impis96213853_impis
imps86221123_imp_s
jambes175914053jambes
jambs166014623jam_bs
jams135231073jam__s
japes146322823ja_pes
jaups144810533jaup_s
jumps165116493jump_s
kagus105812033ka_gus
kalpas124112943kalpas
kames115024693kam_es
kamiks11387913kamiks
kanzus1944603kanzus
kapas116021733ka_pas
kaphs144911503ka_phs
kappas144410363kappas
kaput11717063ka_put
kemps135012523kemp_s
kombus1435523kombus
lamas75532793lam_as
lambs95921413lam_bs
lameds94812033lameds
lames75445543lam_es
lamias85020613lamias
lamp86233823lamp__
lampad114510033lampad
lampads12477623lampads
lamped114017543lamped
lampers113817333lampers
lams66552263lam__s
lapis76223153la_pis
laps66848873la_p_s
lapsus8437273lapsus
layups1133993layups
limbus105710383limbus
limpas105513083limpas
limps95522673limp_s
lumps95624983lump_s
lupus74512523_lupus
lymphs1635053lymphs
magus85318753ma_gus
mamas95930773mam_as
mambas125716243mambas
mambos125414493mambos
mameys13449523mameys
mamies104626243mamies
mamluk1434743mamluk
mamluks1543313mamluks
mammas94616403mammas
manus75924933ma_nus
maps86141053ma_p_s
momus96116113mom_us
mumps115619103mump_s
mumus95517283mum_us
mus55946753__m_us
naevus934593naevus
nairus639143nairus
namers84517333namers
names74833363nam_es
napas75924353na_pas
napes74828463na_pes
nappas105511613nappas
nappes104515623nappes
naps66238583na_p_s
nimbus10377283nimbus
nymphs1633503nymphs
oomphs1344723oomphs
opus66420593__opus
osmous8138183osmous
palps94719563palp_s
pampa114913423pamp_a
pamper124316663pamper
pampers133615933pampers
pams85641763pam__s
papas94927493pa_pas
pappous1057463pappous
paps86443453pa_p_s
pareus85420743pareus
parous84024163parous
passus83610293passus
pimps114616983pimp_s
pompous1338063pompous
pomps115316193pomp_s
pumps115520603pump_s
pupus94614043_pupus
pus55547843___pus
quipus17458003quipus
radius73914873radius
rakus94413673ra_kus
ralphs1135373ralphs
ramees84620893ramees
ramets83517393ramets
ramies84630463ramies
ramp85934003ramp__
ramped114617903ramped
rams65950773ram__s
rapes75740723ra_pes
raps66247733ra_p_s
rasps74316663rasp_s
rhamnus1233133rhamnus
rimous8311913rimous
romps94617543romp_s
rumps95922293rump_s
sadhus10298463sadhus
sajous13310583sajous
salpas85116923salpas
salps74423243salp_s
sambas104219263sambas
sambos104315193sambos
sambur10469503sambur
samburs11369343samburs
sameks12409323sameks
samp85733593samp__
sampan102511893sampan
sampans112411003sampans
sample104215013sample
samples112815453samples
samshus12125353samshus
saps65346373sa_p_s
scamps125014173scamp_s
shamus114112813sham_us
simps94719763simp_s
stamps105614023stamp_s
sumps95023433sump_s
swamies123712063swamies
swamis114212293swam_is
swamp125015323swamp__
swamped15498443swamped
swamper14349313swamper
swampers15317473swampers
swampish1844173swampish
swampy16437233swamp_y
swaps104819203swa_p_s
tabus74820923ta_bus
talus55423263ta_lus
tamals84116633tamals
tambur10358713tambur
tamburs11288613tamburs
tamers84224033tamers
tames75242013tam_es
tamis76728733tam_is
tamp86133003tamp__
tampan102512323tampan
tampans113310983tampans
tamped114317043tamped
tamper104618513tamper
tampers113516743tampers
tampon102911233tampon
tampons112711563tampons
tams67247933tam__s
tapas74627713ta_pas
tapes75838603ta_pes
tapis75028863ta_pis
taps66050673ta_p_s
tarps76527113tarp_s
tarsus6310513tarsus
taupes8212673taupes
taus46342733ta__us
taxus125512483ta_xus
tempos103812293tempos
temps95417133temp_s
tempts10439453tempts
tramps105114453tramp_s
tumps95420793tump_s
umps85721943_ump_s
vagus96713813va_gus
valgus1047103valgus
vamp115521543vamp__
vamped144211013vamped
vamper134212653vamper
vampers143111623vampers
vampish1766283vampish
vampy15539403vamp_y
varus85921183va_rus
vatus86114643va_tus
vaus75928923va__us
wabs97337233wa__bs
wackes154717713wackes
wackos155210993wackos
wacks146626283wa_cks
waders109120643waders
wades95634143wa_des
wadies105121203wadies
wadis95223963wa_dis
wadmals1335513wadmals
wadmels1334303wadmels
wadmols1333913wadmols
wads87343143wa__ds
waeful1238123waeful
waes76048603wa__es
wafers124316143wafers
waffs146315473wa_ffs
wafts116920553wa_fts
wagers105122203wagers
wages95330933wa_ges
wagons103911213wagons
wags86140553wa__gs
wahoos122310593wahoos
waifs115719873wa_ifs
wails86631483wa_ils
wains86930873wa_ins
wairs86424063wa_irs
waists97415453waists
waits88333523wa_its
waives123714183waives
wakens135012043wakens
wakers134822493wakers
wakes126633653wa_kes
walers94824463walers
wales86142833wa_les
walies95324523walies
walks126218503wa_lks
walkup1534193walkup
walkups1633013walkups
wallas95719393wallas
walls85529383wa_lls
walnut939433walnut
walnuts1033843walnuts
wamble134415753wamble
wambles143714023wambles
wambly16388663wambly
wame95035483wam__e
wamefous1643763wamefous
wameful1535673wameful
wamefuls1643863wamefuls
wammuses1543493wammuses
wamuses1237023wamuses
wands96425483wa_nds
wanes85040883wa_nes
wangun1037103wangun
wanguns1135023wanguns
wanks126124483wa_nks
wans76452273wa__ns
wants87932213wa_nts
wap86553373wa_p__
wapped144416473wapped
wards97734403wa_rds
wares88250583wa_res
warks127932403wa_rks
warmers124514293warmers
warms107726853wa_rms
warmths1583783warmths
warmup1335343warmup
warns87231003wa_rns
warp95635003warp__
warped124816413warped
warper114015583warper
warpers123413583warpers
wars78659803wa__rs
warts814840403wa_rts
was68767563wa___s
washes124425493washes
washup1435323washup
washups1534683washups
wasp95626853wasp__
waspish1586923waspish
waspy135410993wasp_y
wastes96224883wastes
wasts87433673wa_sts
watapes12228383watapes
wataps11248683wataps
waters95030633waters
wats77555883wa__ts
watts86923093wa_tts
wauk115220593wa__uk
wauks125515163wa_uks
waul76927313wa__ul
wauls86120553wa_uls
waur76819903wa__ur
wavers125022473wavers
waves115633923wa_ves
waveys15597013waveys
wavies125019843wavies
wawls115416473wa_wls
waws106834903wa__ws
waxers164014303waxers
waxes155825503wa_xes
ways107737953wa__ys
wazoos18288553wazoos
weeps104120563weep_s
whams135515643wham__s
whaps135115163whap_s
whaups14405753whaup_s
whips134917083whip_s
whomps16457603whomp_s
whops135013933whop_s
whumps16427093whump_s
whups134210003whup_s
wimp115521523wimp__
wimped144211513wimped
wimpish1765693wimpish
wimple133611363wimple
wimples143311173wimples
wimpy155911923wimp_y
wipes104827083w_ipes
wisps105214183wisp_s
womans114613653womans
wombs125813343wom_bs
woops104917523woop_s
wops96634153w_op_s
wraps105617153wrap_s
yamens114010823yamens
yams95330733yam__s
yamun10419273yam_un
yamuns11336513yamuns
yaps95933523ya_p_s
yaups105910743yaup_s
yawps13628793yawp_s
zamias174212923zamias
zaps156826893za_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.390458182.1
2DLD Change Limit1127165005.40620850.2
3Display Results5005000.1563205.1
 (SQL Overall)1786915005.95230022.0
 
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.