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

322 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
yippies1427929(None) 
hippies142813741hippies
yippie13277841yippie_
yuppies14339261yuppies
buppies133011062buppies
chippies17309752chippies
dippier123111392dippier
dippiest132511132dippiest
fipples14298652fipples
gipsies1039902gipsies
guppies123310522guppies
hippie132811242hippie_
hippier143212102hippier
hippiest152611612hippiest
koppies153210012koppies
lippier112710572lippier
lippiest122310612lippiest
nappies114613392nappies
nippier11319832nippier
nippiest12279972nippiest
nipples11319662nipples
pappies103214822pappies
pippins10319752pippins
poppies102816192poppies
puppies103212612puppies
ripples113513292ripples
tippier113210542tippier
tippiest122310012tippiest
tipples112811252tipples
yipes106017842yi_p_es
yipped143613282yipp_ed
yippee132810742yipp_ee
yipping152710682yipping
yuppie13297132yuppie_
zippier20308192zippier
zippiest21248092zippiest
apples104315763_apples
applies11311213applies
atopies92816433atopies
bialies93618413bialies
biddies113514493biddies
biffies152710853biffies
biggies113813523biggies
bikies124515163bi_kies
bilbies114712343bilbies
billies93923503billies
biopics13318543biopics
biopsies1237383biopsies
birdies104016213birdies
birkies133712433birkies
buppie12288733buppie_
chappies172610093chappies
chippie16297693chippie_
chippier17297673chippier
chippiest18256803chippiest
cissies94116153cissies
cities84524853ci_ties
civies114116443ci_vies
civvies1555843civvies
copies104130303_copies
coppices1638243coppices
cowpies143314283cowpies
crappies142911153crappies
cripples14298403cripples
croppies143111133croppies
cuppier1368323cuppier
cuppiest1448193cuppiest
dapples1238993dapples
diapirs10347643diapirs
diaries83321953diaries
dickies143416343dickies
didies84621833di_dies
dillies84122153dillies
dimples122813213dimples
dingies93618243dingies
dinkies123716033dinkies
diploes101111483diploes
dipodies1238413dipodies
dipoles101013753dipoles
dipped123517493dipp_ed
dipper114017783dipp_er
dippers123615173dippers
dippiness1435973dippiness
dipping134014833dipping
dirties83119383dirties
ditties83116983ditties
divvies1457663divvies
dizzies16279753dizzies
drippier1385043drippier
drippiest1445363drippiest
empties11712243empties
espies83716803_espies
fifties132111083fifties
fillies103420253fillies
fipple13329063fipple_
floppies1546813floppies
gappier12369843gappier
gappiest13259473gappiest
giddies103713363giddies
gillies84120963gillies
gimmies123010113gimmies
gimpier12247943gimpier
gimpiest1338473gimpiest
gipped124815903gipp_ed
gipper114215303gipp_er
gippers123212073gippers
gipping133813123gipping
gipsied1135873gipsied
girlies83013703girlies
grippes124810373gripp_es
grippier1355203grippier
grippiest1435143grippiest
gypsies1335953gypsies
happier143312033happier
happiest152411673happiest
harpies123818313harpies
hickies163614743hickies
hinnies103615103hinnies
hiplines13310583hiplines
hipped144317693hipp_ed
hipper133818023hipp_er
hippest14219753hipp_est
hippieish1941843hippieish
hippiness1635463hippiness
hipping153915103hipping
hippish1736183hippish
hippos13408433hipp_os
hirples12149643hirples
hissies103915823hissies
hoppier143110703hoppier
hoppiest152610723hoppiest
hopples142810713hopples
immies102412443_immies
impis96213853_impi_s
implies11312123implies
indies73822783_indies
ivies84215763_i_vies
jiffies20327473jiffies
jimmies18328783jimmies
kelpies13289903kelpies
kewpies16246923kewpies
kiddies133412283kiddies
killies113318113killies
kilties113014143kilties
kipped153114573kipp_ed
kippen14299013kipp_en
kipper143414203kipp_er
kippers153211423kippers
kipping163311873kipping
kitties113213623kitties
koppie14277873koppie_
lilies63021413li_lies
lindies8416583lindies
lipases9209483lipases
lipides103810623lipides
lipids94310923li_pids
lipins85016883li_pins
lipoids1038233lipoids
lipped114419543lipp_ed
lippen103911403lipp_en
lippens11328533lippens
lipper104219633lipp_er
lippers113416433lippers
lippiness1335413lippiness
lipping123016073lipping
lippings13296093lippings
loppier11369723loppier
loppiest122410103loppiest
magpies12310363magpies
middies113116153middies
minnies93617363minnies
mislies92922283mislies
missies93423983missies
myopies14309713myopies
nappes104515623napp_es
nappie104112263nappie_
nappier114411173nappier
nappiest122510883nappiest
nifties102612503nifties
ninnies73713613ninnies
nipped113615853nipp_ed
nipper103715713nipp_er
nippers113012613nippers
nippily1444713nippily
nippiness1334713nippiness
nipping123412873nipping
nipple103410373nipple_
nippled12307643nippled
nixies135313873ni_xies
pappier103511593pappier
pappiest112611113pappiest
peppier10268323peppier
peppiest11278563peppiest
pies66949603___pies
pieties9419223pieties
piggies113813483piggies
pigmies122610993pigmies
pimples133012423pimples
pinkies133818263pinkies
pinnies93318443pinnies
pipages1289423pipages
pipes96030143pi_p_es
pipier104913983pi_pier
pipiest113114493pi_piest
pipits104713063pi_pits
pipkins15328183pipkins
pipped104516543pipp_ed
pippin92810303pippi_n
pipping113414743pipping
pities83828083pi_ties
pixies154915513pi_xies
plies74526513__plies
poppied11388983poppied
popples103011873popples
popsies112816463popsies
potpies113116173potpies
preppies1149683preppies
pries74339533__pries
quippier2133773quippier
quippiest2243983quippiest
rappees113611453rappees
replies94521043replies
rimples113114223rimples
ripes75435773ri_p_es
ripped114419013ripp_ed
ripper103518653ripp_er
rippers114115023rippers
ripping123315743ripping
ripple103413913ripple_
rippled123110273rippled
rippler113210103rippler
ripplers12337113ripplers
ripplet113412583ripplet
ripplets12316733ripplets
ripplier1234463ripplier
rippliest1334763rippliest
riptides1136413riptides
sappier113613113sappier
sappiest122612573sappiest
sickies133717503sickies
silkies113715693silkies
sillies73425073sillies
simples113014943simples
sipes76036953si_p_es
sipped113720633sipp_ed
sipper103920983sipp_er
sippers113117743sippers
sippet103519393sipp_et
sippets113310173sippets
sipping123117433sipping
sissies73716603sissies
sixties14310973sixties
slippier1256533slippier
slippiest1346463slippiest
snippier1255793snippier
snippiest1345713snippiest
sophies12314603sophies
soppier112711583soppier
soppiest122511933soppiest
spies76037623__spies
stipples1247023stipples
supples11511283supples
supplies1268823supplies
swipples1534843swipples
tawpies12309873tawpies
tidies74721833ti_dies
tiepins939463tiepins
tipis76019923ti_pi_s
tipped114418263tipp_ed
tipper103918413tipp_er
tippers113414343tippers
tippet103917873tipp_et
tippets11339373tippets
tipping122814973tipping
tipple103411913tipple_
tippled12358393tippled
tippler11348343tippler
tipplers12336353tipplers
tipsier9268893tipsier
tipsiest10228953tipsiest
tiptoes939173tiptoes
titties73617363titties
tizzies15287893tizzies
topples113111653topples
trippier1246623trippier
trippiest1336583trippiest
typifies1644963typifies
uppiles11208263_uppiles
vichies15310623vichies
weepies122811743weepies
whippier18265823whippier
whippiest19265113whippiest
wicopies1545983wicopies
widdies123514033widdies
wienies102213683wienies
willies103920153willies
wimpier14248053wimpier
wimpiest1538763wimpiest
wimples143311173wimples
wipes104827083wi_p_es
wispier12249403wispier
wispiest1339513wispiest
withies133913543withies
yabbies14279643yabbies
yapped144415143yapp_ed
yapper133714513yapp_er
yappers144012253yappers
yapping153412613yapping
yikes125117753yi__kes
yipe96722173yi_p_e_
yips95226693yi_p__s
yowies123913733y_owies
yummies14359533yummies
yuppieish1951033yuppieish
yuppifies1942693yuppifies
yuppify2042163yuppify
zappier20458373zappier
zappiest21228023zappiest
zipped203612983zipp_ed
zipper193813123zipp_er
zippers203310373zippers
zipping212910573zipping

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.1561145455.1
2DLD Change Limit1340273228.14316459.2
3Display Results3223220.1232617.9
 (SQL Overall)1786913228.42221217.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.