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

288 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
yippee13281074(None) 
yipped143613281yipped
yippie13277841yippie
dipped123517492dipped
dipper114017792dipper
fipple13329062fipple
gipped124815902gipped
gipper114215302gipper
hipped144317692hipped
hipper133818022hipper
hippie132811242hippie
kipped153114572kipped
kippen14299012kippen
kipper143414212kipper
lipped114419542lipped
lippen103911402lippen
lipper104219632lipper
nipped113615852nipped
nipper103715712nipper
nipple103410372nipple
pipped104516542pipped
rappee103618672rappee
ripped114419012ripped
ripper103518652ripper
ripple103413912ripple
sipped113720632sipped
sipper103920992sipper
sippet103519392sippet
tipped114418262tipped
tipper103918412tipper
tippet103917872tippet
tipple103411912tipple
yapped144415142yapped
yapper133714512yapper
yipe96722182yi_p_e
yipes106017842yi_pes
yippies14279292yippies
yuppie13297132yuppie
zipped203612982zipped
zipper193813122zipper
appel94615893_appel
apple94517673_apple
biped104718833bi_ped
blipped14377193blipped
bopped134413403bopped
bopper123813833bopper
buppie12288733buppie
capped134721853capped
capper124421983capper
chipped174110813chipped
chipper163912583chipper
chippie16297693chippie
cipher133710263cipher
clipped14439833clipped
clipper133710323clipper
copped135221253copped
copper124321893copper
cripple13378583cripple
cupped134413983cupped
cupper124313863cupper
dapped124516763dapped
dapper114016633dapper
dapple1138853dapple
diaper94513113diaper
dimple113512793dimple
diplex16408053diplex
diploe9810153diploe
dipnet91317473dipnet
dipole91112853dipole
dippers123615183dippers
dippier123111393dippier
dippy135111543dipp_y
dispel9310323dispel
dripped13408083dripped
dripper12349233dripper
dupped124411643dupped
epee64628503__epee
epopee10312503epopee
fipples14298653fipples
flipped15358513flipped
flipper14389143flipper
fopped144012673fopped
gapped124217123gapped
giftee103512083giftee
gimped123911473gimped
gippers123212083gippers
grippe115310323gripp_e
gripped13419343gripped
gripper124410713gripper
grippes124810373grippes
gripple12416613gripple
gypped15377113gypped
gypper14347293gypper
happed144820103happed
happen134812193happen
hepper133412663hepper
hippest14219753hippest
hippier143212103hippier
hippies142813743hippies
hippo12369063hipp_o
hippos13408433hippos
hippy155112793hipp_y
hiree85427803hi_ree
hirple11158973hirple
hopped144318113hopped
hopper134218483hopper
hopple132910483hopple
imped105117983_imped
impede11469623_impede
impel95711773_impel
imphee13310353imphee
jimper17389863jimper
jinnee13411573jinnee
kepped15309543kepped
keppen14346573keppen
kippered17255623kippered
kipperer16294723kipperer
kippers153211433kippers
koppie14277883koppie
lapped114320033lapped
lapper104319953lapper
lappet103817723lappet
lichee114017973lichee
limped114817123limped
limper104117853limper
limpet103518633limpet
lipase8239103lipase
lipe66839733li_p_e
lipide93511063lipide
lippened13255223lippened
lippens11328533lippens
lippered13287953lippered
lippers113416443lippers
lippier112710573lippier
lippy124511903lipp_y
lisped94113423lisped
lisper84114433lisper
listee64223063listee
lopped114218623lopped
lopper103717203lopper
mapped134015883mapped
mapper124516093mapper
mispen10312173mispen
mopped134114323mopped
mopper126215003mopper
moppet126915093moppet
nappe96114993napp_e
napped114218163napped
napper103718283napper
nappes104515623nappes
nappie104112263nappie
nippers113012623nippers
nippier11319833nippier
nippled12307643nippled
nipples11319663nipples
nippy124911113nipp_y
pee56066513___pee
pepped103113403pepped
pepper93512943pepper
pigpen1136583pigpen
pimped134913483pimped
pimple123512963pimple
pipage1199143pipage
pipe86434433pi_p_e
piped105123163pi_ped
piper96523193pi_per
pipes96030143pi_pes
pipet95533323pi_pet
pipier104913983pipier
pippin92810303pippin
popped104117813popped
popper93615963popper
poppet92717323poppet
popple92710983popple
pree67044733__pree
pupped105013273pupped
puppet93514593puppet
quipped2175163quipped
quipper2095823quipper
rapped114122683rapped
rappees113611453rappees
rappel104211953rappel
rappen103512713rappen
rapper104621573rapper
repped114616723repped
rimple103814583rimple
ripe66038923ri_p_e
riped85226433ri_ped
ripen75619263ri_pen
riper74328403ri_per
ripes75435773ri_pes
rippers114115033rippers
rippled123110273rippled
rippler113210103rippler
ripples113513293ripples
ripplet113412583ripplet
ripply13348003ripply
rupee7321283_rupee
sapped114422013sapped
sapper103822353sapper
shipped153312103shipped
shippen14298863shippen
shipper143514043shipper
sickee124622223sickee
signee73617233signee
simper103616293simper
simple104315173simple
sipe67341043si_p_e
siped84927683si_ped
sipes76036953si_pes
sippers113117753sippers
sippets113310183sippets
siree55238813si_ree
sirree64017343sirree
skipped16358413skipped
skipper15339573skipper
skippet15288463skippet
slipped124711743slipped
slipper113712983slipper
snipped123510043snipped
snipper113911333snipper
snippet113310433snippet
sopped114819903sopped
spree74830863_spree
stipple1146623stipple
supped114415703supped
supper104115433supper
supple10410203supple
swipple1444633swipple
tapped113820053tapped
tapper104419613tapper
tappet103820113tappet
teepee8314363teepee
tepee74724213_tepee
tippers113414353tippers
tippets11339373tippets
tippier113210543tippier
tippled12358393tippled
tippler11348343tippler
tipples112811253tipples
tippy125411793tipp_y
tiptoe838283tiptoe
topee76029953_topee
topped114617723topped
topper103817603topper
topple104411323topple
toupee8316133toupee
tripped123911693tripped
tripper113711923tripper
trippet113714113trippet
tupped114013233tupped
upped103715163_upped
upper93714263_upper
veepee11311483veepee
viper105017303vi_per
wapped144416473wapped
whipped18379333whipped
whipper173611383whipper
whippet17328843whippet
wimped144211513wimped
wimple133611363wimple
wipe94830283wi_p_e
wiped114722083wi_ped
wiper105421293wi_per
wipes104827083wi_pes
wisped123411893wisped
yappers144012253yappers
yauped12408333yauped
yauper11368543yauper
yawped15528103yawped
yawper14437953yawper
yelped12439363yelped
yelper11458783yelper
yikes125117753yi_kes
yince105214253yi_nce
yip87241183yi_p__
yipping152710683yipping
yips95226703yi_p_s
yirred10426963yirred
yogee9518063y_ogee
yuppies14339263yuppies
yuppy15487913yupp_y
zapped204213523zapped
zapper193414023zapper
zippered22244823zippered
zippers203310383zippers
zippier20308193zippier
zippy21518743zipp_y

Search took 5 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.366488226.8
2DLD Change Limit1127162884.48325143.0
3Display Results2882880.0963000.0
 (SQL Overall)1786912884.94536135.7
 
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.