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 “koppies” 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
koppies15321001(None) 
koppie14277881koppie_
poppies102816191poppies
buppies133011062buppies
copies104130302co_pies
coppices1638242coppices
cowpies143314282cowpies
croppies143111132croppies
floppies1546812floppies
guppies123310522guppies
hippies142813742hippies
hoppier143110702hoppier
hoppiest152610722hoppiest
hopples142810712hopples
kelpies13289902kelpies
kewpies16246922kewpies
kopjes1935362ko_pjes
koppas14407602kopp_as
loppier11369722loppier
loppiest122410102loppiest
nappies114613392nappies
pappies103214822pappies
poppied11388982poppied
popples103011872popples
popsies112816462popsies
potpies113116172potpies
puppies103212612puppies
sophies12314612sophies
soppier112711582soppier
soppiest122511932soppiest
topples113111652topples
yippies14279292yippies
yuppies14339262yuppies
apples104315763_apples
applies11311213applies
atopies92816433atopies
biopsies1237383biopsies
bobbies103714563bobbies
boccies133311513boccies
bodies94524143bo_dies
bogies94724313bo_gies
boobies113718203boobies
boodies103721443boodies
boogies103719013boogies
bookies133819403bookies
boonies93422483boonies
booties94124613booties
bopped134413403bopp_ed
bopper123813833bopp_er
boppers133911923boppers
bopping143512033bopping
bossies94116833bossies
bothies12414783bothies
bougies103715183bougies
buppie12288733buppie_
chappies172610093chappies
chippies17309753chippies
choppier17286643choppier
choppiest18226373choppiest
colies84837053co_lies
collies94326583collies
commies133718453commies
compiles14311983compiles
complies14314523complies
conies84338593co_nies
cookies133719273cookies
coolies93824963coolies
cooties93725733cooties
copes97747103co_p_es
copied114618563co_pied
copier103722893co_pier
copiers114215963co_piers
copped135221253copp_ed
copper124321893copp_er
coppers133519753coppers
coppice1537483coppice
coppiced1734823coppiced
copping143918593copping
coppras13327833coppras
copses104922473co_pses
corbies113520123corbies
corpses113913803corpses
corries94026793corries
cosies84932153co_sies
coupes105022523coup_es
couples115317053couples
cowpie133511513cowpie_
cowries124218013cowries
cozies174521413co_zies
crappies142911153crappies
croppie13278793croppie_
cuppier1368323cuppier
cuppiest1448193cuppiest
dapples1238993dapples
dippier123111393dippier
dippiest132511133dippiest
dobbies124113063dobbies
dobies94422093do_bies
doggies103613023doggies
dogies85022253do_gies
doilies84017363doilies
dollies83620983dollies
doobies103915673doobies
doodies94218773doodies
doolies83920713doolies
doozies173812723doozies
dopes84935043do_p_es
dopier93515923do_pier
dopiest103315993do_piest
dories75232363do_ries
dowdies123412733dowdies
dowries114413983dowries
doxies143917853do_xies
doylies114512573doylies
dropsies1138693dropsies
empties11712243empties
epopees1137233epopees
epoxies1637753epoxies
espies83716803_espies
fipples14298653fipples
floppier1554633floppier
floppiest1654773floppiest
fogies104118063fo_gies
folkies143612253folkies
follies103618943follies
foodies113416753foodies
footies103721543footies
fopped144012673fopp_ed
fopperies1666013fopperies
fopping153511133fopping
foppish1735103foppish
forties104323863forties
gappier12369843gappier
gappiest13259473gappiest
gipsies1039903gipsies
gloppier1354673gloppier
gloppiest1444823gloppiest
goalies8316023goalies
gobies95418063go_bies
goodies93516993goodies
goonies83618333goonies
goopier103910573goopier
goopiest112710553goopiest
groupies1137523groupies
gypsies1335953gypsies
happier143312033happier
happiest152411673happiest
harpies123818313harpies
hippie132811243hippie_
hippier143212103hippier
hippiest152611613hippiest
hoagies112811993hoagies
hobbies143813343hobbies
hogties112813993hogties
holies94630033ho_lies
hollies103420813hollies
homies114524723ho_mies
hongies112716473hongies
honkies143015143honkies
hoodies113419833hoodies
hookies144017443hookies
hoopoes121212483hoopoes
hopes105835643ho_p_es
hoplites13310543hoplites
hopped144318113hopp_ed
hopper134218483hopp_er
hoppers143115143hoppers
hopping154115273hopping
hoppings16306523hoppings
hopple132910483hopple_
hoppled15338083hoppled
hospices1587633hospices
hotties103016963hotties
howdies142911953howdies
implies11312123implies
jaloppies2043213jaloppies
jollies143516273jollies
kappas144410363kapp_as
kauries113613193kauries
kebbies1537253kebbies
kellies113516853kellies
kelpie12308613kelpie_
kepis115313363k_epi_s
kepped15309543kepp_ed
keppen14346573kepp_en
kepping16268593kepping
kerries113317913kerries
kewpie15465413kewpie_
kiddies133412283kiddies
killies113318113killies
kilties113014143kilties
kipped153114573kipp_ed
kippen14299013kipp_en
kipper143414213kipp_er
kippers153211433kippers
kipping163311873kipping
kitties113213623kitties
knopped16355453knopp_ed
koines10415733ko_ines
kois85129403ko__i_s
kojis16468443ko_ji_s
kookie9389843kookie_
kookier10398283kookier
kookiest11268133kookiest
kopecks1433073kopecks
kopek1037813ko_p_ek
kopeks1134603ko_peks
kophs145010933ko_p_hs
kopje1835273ko_pje_
koppa13397293kopp__a
kops107031293ko_p__s
koumis1237623koumi_s
koumises1444593koumises
koumiss1344313koumiss
kouprey1652793kouprey
koupreys1741733koupreys
kyries133411373k_yries
lippier112710573lippier
lippiest122310613lippiest
lobbies113612463lobbies
lollies73116923lollies
longies82916553longies
loobies93814103loobies
looies65025833lo_oies
loonies73919543loonies
loopier93711193loopier
loopiest103011313loopiest
lopes76437343lo_p_es
lopped114218623lopp_ed
lopper103717203lopp_er
loppers113014103loppers
lopping123815223lopping
lories64933043lo_ries
lorries74518343lorries
louies64525103lo_uies
loupes84918053loup_es
magpies12310363magpies
moggies113111723moggies
molies84429513mo_lies
mollies93420233mollies
mommies103912273mommies
monies83233163mo_nies
moperies12313873moperies
mopes95134983mo_p_es
mopier103914783mo_pier
mopiest113014293mo_piest
mopokes1536693mopokes
mopped134114323mopp_ed
mopper126215003mopp_er
moppers133412463moppers
moppet126915093mopp_et
moppets13307163moppets
mopping143411473mopping
movies115118453mo_vies
moxies154317403mo_xies
myopies14309723myopies
nappes104515623napp_es
nappie104112263nappie_
nappier114411173nappier
nappiest122510883nappiest
nippier11319833nippier
nippiest12279973nippiest
nipples11319663nipples
noddies93512043noddies
noogies82814583noogies
nookies113414963nookies
nopales93812523nopales
okapis1235393okapi_s
oldies7314423_oldies
opes65942613_o_p_es
ophites12310103_ophites
opines84820703_opines
oppose1039193_oppose
opposes1149243_opposes
oppress1135993_oppress
opsins8411713_opsins
optics102810183_optics
optimes1148473_optimes
opuses84012243_opuses
orgies72316093_orgies
orpines94414793_orpines
orpins83614163_orpins
ouphes113614633_ouphes
pappier103511593pappier
pappiest112611113pappiest
peppier10268323peppier
peppiest11278563peppiest
pies66949603___pies
pipes96030143__pipes
pippins10319753pippins
plies74526513__plies
poesies93217403poesies
pogies94123543po_gies
pokies125921333po_kies
polies84034583po_lies
pommies133712843pommies
ponies84833463po_nies
poperies12316793poperies
popes95933813po_p_es
poplins11313153poplins
poppas93710713popp_as
popped104117813popp_ed
popper93615963popp_er
poppers103414863poppers
poppet92717323popp_et
poppets10338853poppets
popping113715413popping
popple92710983popple_
poppled11339243poppled
popsie103013053popsie_
porgies103017003porgies
porkies133416493porkies
porkpies1636193porkpies
posies84431433po_sies
posties93128813posties
potpie103412433potpie_
potsies93019483potsies
potties93723543potties
preppies1149683preppies
pries74339533__pries
rappees113611453rappees
replies94521043replies
ripples113513293ripples
roadies83317443roadies
roofies103014413roofies
rookies113917103rookies
roomies93017243roomies
roperies10315763roperies
ropes75940063ro_p_es
ropier84118803ro_pier
ropiest93317773ro_piest
roupier9319493roupier
roupiest102610293roupiest
rowdies113112693rowdies
sappier113613113sappier
sappiest122612573sappiest
shoppes143411393shopp_es
sloppier1255703sloppier
sloppiest1345973sloppiest
soapier93411713soapier
soapiest102412843soapiest
soddies92312853soddies
softies103414613softies
sonnies7315223sonnies
sopites93817173sopites
sopped114819903sopp_ed
soppiness1336543soppiness
sopping123917203sopping
sorties74126403sorties
soupier93111753soupier
soupiest102212913soupiest
spies76037623__spies
stopples1236953stopples
supples11511283supples
supplies1268833supplies
tawpies12309873tawpies
tippier113210543tippier
tippiest122310013tippiest
tipples112811253tipples
toadies82914863toadies
tobies84521023to_bies
toddies93011993toddies
todies74223553to_dies
toffies133210213toffies
tommies113812983tommies
toonies73719883toonies
topazes1857313topazes
topees85519703to_pees
topes76941763to_p_es
tophes115218423to_phes
topics104714583to_pics
topis76025833to_pi_s
toplines102412563toplines
topped114617723topp_ed
topper103817603topp_er
toppers113914603toppers
topping123514623topping
toppings13286423toppings
topple104411323topple_
toppled12348843toppled
topsides1137203topsides
topspins1244873topspins
tories65435883to_ries
torpids1037373torpids
toupees938513toupees
towies93521193to_wies
townies103113623townies
trophies13413673trophies
uppiles11208263_uppiles
weepies122811743weepies
whoopies16267373whoopies
woodies113517153woodies
woolies104117363woolies
woopses1237883woopses
worries104117133worries
yippie13277843yippie_
yowies123913733yo_wies
yuppie13297133yuppie_
zappier20458373zappier
zappiest21228023zappiest
zippier20308193zippier
zippiest21248093zippiest
zombies2037993zombies

Search took 7 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.390458182.1
2DLD Change Limit1340274036.08022043.9
3Display Results4034030.1402878.6
 (SQL Overall)1786914036.61027033.4
 
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.