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

403 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
whapped1836757(None) 
chapped172711441chapped
happed144820101_happed
wapped144416471w_apped
whapper17348271whapper
whipped18379331whipped
whopped18358001whopped
whupped18365411whupped
wrapped15338021wrapped
capped134721852_capped
champed174111482champed
chipped174110812chipped
chopped174511002chopped
clapped143511172clapped
crapped143912622crapped
dapped124516762_dapped
flapped15328252flapped
frapped15318852frapped
gapped124217122_gapped
happen134812192_happen
harped124418402_harped
hasped125014442_hasped
hipped144317692_hipped
hopped144318112_hopped
knapped16397102knapped
lapped114320032_lapped
mapped134015882_mapped
napped114218162_napped
rapped114122682_rapped
sapped114422012_sapped
shaped125020102sha_ped
sharped134112052sharped
shipped153312102shipped
shopped153512212shopped
slapped123511842slapped
snapped124611202snapped
swapped15429142swapped
tapped113820052_tapped
trapped124512212trapped
warped124816412w_arped
whacked20458622whacked
whaled134612032wha_led
whammed18345132whammed
whanged15447612whanged
whappers18276742whappers
wharfed1734412wharfed
wheeped16387502wheeped
whelped16355632whelped
whipper173611382whipper
whippet17328842whippet
whomped18345472whomped
whooped16326932whooped
whopper17328502whopper
whumped18335632whumped
wrapper14368332wrapper
yapped144415142_yapped
zapped204213522_zapped
adapted1135843adapted
amped104820513__amped
aped78538153__a_ped
appel94615893__appel
append1138273__append
becapped1733933becapped
bewrapped1962513bewrapped
blipped14377193blipped
bopped134413403_bopped
camped134720233_camped
caped104931803_ca_ped
capper124421983_capper
carped115923763_carped
chafed154813913cha_fed
chaffed19387703chaffed
chained133812693chained
chaired134211243chaired
chalked17449863chalked
champer163813413champer
chanced154113213chanced
changed144214143changed
chanted134015953chanted
chape125221143cha_pe_
chapel134911373cha_pel
chapes135421873cha_pes
chaplet14512253chaplet
chapmen1637283chapmen
chappie16298653chappie
chappies172610093chappies
chapter144213853chapter
chared125423693cha_red
charged144614023charged
charked174814013charked
charmed154714253charmed
charred134614483charred
charted135116853charted
chased125019293cha_sed
chasmed154710173chasmed
chassed134712133chassed
chatted133411893chatted
chawed155214603cha_wed
cheeped153410593cheeped
chipper163912583chipper
chirped15379783chirped
chomped17329773chomped
chopper163611893chopper
chumped17379493chumped
clamped144012043clamped
clapper134011863clapper
clasped123610443clasped
clipped14439833clipped
clopped143611523clopped
coapted123911503coapted
copped135221253_copped
cramped144712183cramped
craped116120523cra_ped
crapper133913193crapper
cropped143812063cropped
cupped134413983_cupped
damped124315583_damped
dapper114016633_dapper
dappled1336393_dappled
dewlapped1841953dewlapped
dipped123517493_dipped
draped105314363dra_ped
dripped13408083dripped
dropped13329283dropped
dupped124411643_dupped
elapsed1056103elapsed
enwrapped1742793enwrapped
exapted1736073exapted
flapper14359203flapper
flipped15358513flipped
flopped15338763flopped
fopped144012673_fopped
frappe13286953frappe_
frappes14328383frappes
gaped96123533_ga_ped
gasped104814293_gasped
gawped13509073_gawped
gipped124815903_gipped
glopped13347613glopped
graphed1498473graphed
grappled14336093grappled
grasped11409063grasped
gripped13419343gripped
gypped15377113_gypped
hacked164923513_hacked
haded105227623_ha_ded
haed86338583_ha__ed
hafted134713833_hafted
hagged124317703_hagged
hailed104122743_hailed
haired105117173_haired
haled95335823_ha_led
haloed104717603_haloed
halted105019603_halted
halved134813903_halved
hammed144116973_hammed
hamper134518653_hamper
handed114919983_handed
hanged114222393_hanged
hanked144220603_hanked
hanted104124313_hanted
happened1635653_happened
happens14359173_happens
happier143312033_happier
happy155813533_happ_y
hapten115312983_hapten
hared95742183_ha_red
harked145422553_harked
harmed125218833_harmed
harper115018403_harper
hashed136021943_hashed
hasted105125283_hasted
hated95734023_ha_ted
hatred104814333_hatred
hatted104921513_hatted
hauled104415213_hauled
hawed126025423_ha_wed
hawked174712673_hawked
hayed125822013_ha_yed
hazed185222203_ha_zed
heaped124516903_heaped
helped124714153_helped
hepper133412663_hepper
hipper133818023_hipper
hooped125518183_hooped
hoped115628183_h_oped
hopper134218483_hopper
hoppled15338083_hoppled
humped144015243_humped
hyped145313333_h_yped
hypoed1547923_hypoed
inwrapped1742643inwrapped
japed156217633_ja_ped
jauped16457903_jauped
kepped15309533_kepped
kipped153114573_kipped
knapper15387153knapper
knopped16355443knopped
lamped114017543_lamped
lapper104319953_lapper
lappet103817723_lappet
lapsed94712583_lapsed
leaped94317773lea_ped
lipped114419543_lipped
lopped114218623_lopped
mapper124516093_mapper
mopped134114323_mopped
nappe96114993_nappe_
napper103718283_napper
nappes104515623_nappes
nipped113615853_nipped
palped114513643_palped
pepped103113393_pepped
phased124011973pha_sed
pipped104516543_pipped
plopped11288773plopped
popped104117813_popped
prepped11329893prepped
propped113311953propped
pupped105013273_pupped
quipped2175163quipped
ramped114617903_ramped
raped85334623_ra_ped
rappee103618673_rappee
rappel104211953_rappel
rappen103512713_rappen
rapper104621573_rapper
rasped94715203_rasped
reaped94122453rea_ped
recapped1535943recapped
remapped1534913remapped
repped114616723_repped
rewrapped1763023rewrapped
rhaphe1433423rhaphe_
rhaphes1534703rhaphes
ripped114419013_ripped
sapper103822353_sapper
scalped124411993scalped
scamped144711963scamped
scaped115519553sca_ped
scarped124314403scarped
schappe1635263schappe_
schappes1736033schappes
scrapped1556533scrapped
shacked174015393shacked
shaded114518873sha_ded
shafted14288813shafted
shagged134210133shagged
shaled105023953sha_led
shamed125120213sha_med
shammed153911423shammed
shanked153212123shanked
shape105125113sha_pe_
shapen114414653sha_pen
shaper114119933sha_per
shapes115124943sha_pes
shared105829063sha_red
sharked153613913sharked
sharpen12389723sharpen
sharper124312703sharper
shauled1148793shauled
shaved135118383sha_ved
shawed134817233sha_wed
shawled1437773shawled
shippen14298863shippen
shipper143514043shipper
shlepped1633643shlepped
shoppe133110323shoppe_
shopper143312633shopper
shoppes143411393shoppes
sipped113720633_sipped
skipped16358413skipped
slapper113512463slapper
slipped124711743slipped
slopped123511443slopped
snapper113512073snapper
snipped123510043snipped
soaped95817973soa_ped
sopped114819903_sopped
stamped124812813stamped
stapled103613703stapled
stepped123210053stepped
stopped124512203stopped
strapped1357823strapped
supped114415703_supped
swamped15498443swamped
swapper14359703swapper
swopped15437673swopped
tamped114317043_tamped
taped85327423_ta_ped
tapper104419613_tapper
tappet103820113_tappet
thacked173810203thacked
thanked15469153thanked
thawed13458463tha_wed
thumped15387413thumped
tipped114418263_tipped
topped114617723_topped
tramped124312433tramped
trapper113912803trapper
tripped123911693tripped
tupped114013233_tupped
uncapped1556693uncapped
unmapped1535173unmapped
untapped1376613untapped
unwhipped2042363unwhipped
unwrapped1784133unwrapped
upped103715163__upped
vamped144211013_vamped
wadded124014173w_added
waded106024753w_a_ded
waffed16459793w_affed
wafted134012143w_afted
waged104822783w_a_ged
wagged124616123w_agged
waifed134011033w_aifed
wailed104823593w_ailed
waired106015833w_aired
waited103819773w_aited
waived134511283w_aived
waked135626753w_a_ked
waled94330993w_a_led
walked145313783w_alked
walled104021293w_alled
waned95831783w_a_ned
wanked144517153w_anked
wanned104318013w_anned
wanted104319723w_anted
warded115021043w_arded
wared96339873w_a_red
warked144421213w_arked
warmed124516893w_armed
warned104018913w_arned
warper114015583w_arper
warred104019843w_arred
warted104223233w_arted
washed135521503w_ashed
wasted104423023w_asted
wauked144210573w_auked
wauled104713963w_auled
waved125223583w_a_ved
wawled133811703w_awled
waxed166018483w_a_xed
weaned103816153wea_ned
weaponed1445493weaponed
wearied112911803wearied
weaved133913483wea_ved
whacker19368503whacker
whale115517433wha_le_
whaler124611973wha_ler
whales124716943wha_les
whangee14268613whangee
whap125119643wha_p__
whapping19317113whapping
whaps135115163wha_p_s
wharve15456203wharve_
wharves16457133wharves
whaup13458883whaup__
whaups14405753whaup_s
wheeled14318463wheeled
wheepled1733293wheepled
wheezed23296453wheezed
whelmed16375153whelmed
whetted14256693whetted
whidded1634423whidded
whiffed2064473whiffed
whiled134514133wh_iled
whimper17297723whimper
whined134715203wh_ined
whinged15409153whinged
whippers18329043whippers
whippets18255253whippets
whippier18265823whippier
whippy19385843whipp_y
whirled14368043whirled
whirred14386933whirred
whished17428023whished
whisked18336913whisked
whisper15298013whisper
whisted144010013whisted
whited134814083wh_ited
whizzed2234063whizzed
whoofed17374513whoofed
whoopee15287513whoopee
whooper15297153whooper
whoppers18297533whoppers
whored135512123wh_ored
whorled14366903whorled
wimped144211513w_imped
wimpled15338823wimpled
wiped114722083w__iped
wisped123411893w_isped
woaded115211603woa_ded
woopsed1344733woopsed
wracked174110113wracked
wrappers15306933wrappers
wrathed14298523wrathed
yapper133714513_yapper
yauped12408333_yauped
yawped15528103_yawped
yipped143613283_yipped
zapper193414023_zapper
zipped203612983_zipped

Search took 9 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.1401276364.3
2DLD Change Limit1340274038.47015823.7
3Display Results4034030.1402878.6
 (SQL Overall)1786914038.75020421.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.