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

304 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
koppie1427788(None) 
koppies153210011koppies
buppie12288732buppie
coppice1537482coppice
cowpie133511512cowpie
croppie13278792croppie
hippie132811242hippie
hoppier143110702hoppier
hopple132910482hopple
kelpie12308612kelpie
kewpie15465412kewpie
kookie9389842kookie
kopje1835272ko_pje
koppa13397292kopp_a
koppas14407602koppas
loppier11369722loppier
nappie104112262nappie
poppied11388982poppied
poppies102816192poppies
popple92710982popple
popsie103013052popsie
potpie103412432potpie
soppier112711582soppier
topple104411322topple
yippie13277842yippie
yuppie13297132yuppie
apple94517673_apple
boccie123311453boccie
bogie89524103bo_gie
bonnie85314853bonnie
boobie104015293boobie
boogie93515993boogie
bookie123516003bookie
bootie85421163bootie
bopped134413403bopped
bopper123813833bopper
bopping143512033bopping
bougie93613273bougie
buppies133011063buppies
chappie16298653chappie
chippie16297693chippie
choppier17286643choppier
collie83621993collie
commie124215523commie
compile13312443compile
cookie123716043cookie
coolie83821603coolie
cootie84223093cootie
cope86847383co_p_e
copied114618563co_pied
copier103722893co_pier
copies104130303co_pies
copped135221253copped
copper124321893copper
coppiced1734823coppiced
coppices1638243coppices
copping143918593copping
coppra12306833coppra
copse95623923co_pse
corbie103618203corbie
corpse104013403corpse
corrie83621223corrie
cosie74728263co_sie
coupe96023483coup_e
couple104415963couple
cowpies143314283cowpies
cowrie113814283cowrie
cozie163519133co_zie
crappie13298983crappie
croppies143111133croppies
cuppier1368323cuppier
dapple1138853dapple
dippier123111393dippier
dobie84920333do_bie
doggie93910893doggie
dogie75222793do_gie
donsie7613643donsie
doobie94712683doobie
doolie73916833doolie
doozie163910653doozie
dope76038893do_p_e
dopier93515923do_pier
dormie9312623dormie
dowie94721143do_wie
doxie136017153do_xie
epopee10312503epopee
fipple13329063fipple
floppier1554633floppier
floppies1546813floppies
fogie96719003fo_gie
folkie13369613folkie
foodie104413843foodie
footie94718143footie
fopped144012673fopped
fopping153511133fopping
foppish1735103foppish
gappier12369843gappier
gloppier1354673gloppier
goalie7413163goalie
goodie83613993goodie
goonie73615563goonie
goopier103910573goopier
gopik1257533go_pik
groupie1045783groupie
guppies123310523guppies
happier143312033happier
hempie132410563hempie
hippier143212103hippier
hippies142813743hippies
hoagie102310013hoagie
hogtie102711773hogtie
homie104622533ho_mie
honkie133011673honkie
hoodie105116143hoodie
hoolie93217783hoolie
hoopoe11911233hoopoe
hope96639673ho_p_e
hoplite12311073hoplite
hopped144318113hopped
hopper134218483hopper
hoppiest152610723hoppiest
hopping154115273hopping
hoppled15338083hoppled
hopples142810713hopples
hoppy154912353hopp_y
hospice14117063hospice
hottie92514383hottie
howdie13349733howdie
kappa13469743kapp_a
kappas144410363kappas
kebbie1435813kebbie
kelpies13289903kelpies
kepi105315633k_epi_
kepis115313363k_epis
kepped15309543kepped
keppen14346573keppen
kepping16268593kepping
kewpies16246923kewpies
kiddie12359393kiddie
killie104114893killie
kiltie103210963kiltie
kipped153114573kipped
kippen14299013kippen
kipper143414213kipper
kipping163311873kipping
knopped16355453knopped
koi77534753ko__i_
koine9516483ko_ine
kois85129403ko__is
koji155611123ko_ji_
kojis16468443ko_jis
kookier10398283kookier
kop97440203ko_p__
kopeck1333423kopeck
kopek1037813ko_pek
kopeks1134603kopeks
koph135816543ko_p_h
kophs145010933ko_phs
kopjes1935363kopjes
kops107031293ko_p_s
korai97018523korai_
kore85834163ko__re
koumis1237623koumis
kouprey1652793kouprey
kyrie123712903k_yrie
lippier112710573lippier
loggie84011993loggie
looie55624243lo_oie
loonie64216453loonie
loopier93711193loopier
lope65941923lo_p_e
lopped114218623lopped
lopper103717203lopper
loppiest122410103loppiest
lopping123815223lopping
loppy125911663lopp_y
louie55023513lo_uie
loupe75319513loup_e
magpie1139093magpie
moggie103210103moggie
mollie83517103mollie
monie75631653mo_nie
mope86838043mo_p_e
mopier103914783mo_pier
mopoke1436633mopoke
mopped134114323mopped
mopper126215003mopper
moppet126915093moppet
mopping143411473mopping
movie105319133mo_vie
moxie144018123mo_xie
nappe96114993napp_e
nappier114411173nappier
nappies114613393nappies
nippier11319833nippier
nipple103410373nipple
noogie73612313noogie
nookie103712433nookie
nope65934193no_p_e
okapi1136613okapi_
okapis1235393okapis
oldie6415473_oldie
oorie53026363_oorie
ope56845243_o_p_e
ophite11410563_ophite
opine77422463_opine
oppose1039193_oppose
opsin7613473_opsin
optic93715183_optic
optime1079353_optime
orpin73415533_orpin
orpine83914483_orpine
ouphe104413263_ouphe
ourie54027303_ourie
pappi84810893pappi_
pappier103511593pappier
pappies103214823pappies
peppier10268323peppier
pie55457403___pie
pipe86434433__pipe
pippin92810303pippin
plie65127393__plie
pommie123710503pommie
pope85535613po_p_e
poplin10413483poplin
poppa8409893popp_a
poppas93710713poppas
popped104117813popped
popper93615963popper
poppet92717323poppet
popping113715413popping
poppled11339243poppled
popples103011873popples
poppy114813193popp_y
popsies112816463popsies
porkpie1544673porkpie
postie84123963postie
potpies113116173potpies
potsie83916033potsie
preppie1058093preppie
puppies103212613puppies
rappee103618673rappee
ripple103413913ripple
roadie72813813roadie
roofie93411173roofie
rookie103613263rookie
roomie83013873roomie
rope65542913ro_p_e
ropier84118803ro_pier
roupier9319493roupier
sappier113613113sappier
shoppe133110323shopp_e
sloppier1255703sloppier
soapier93411713soapier
softie93312483softie
sonsie6614863sonsie
sophies12314613sophies
sopite84917713sopite
sopped114819903sopped
soppiest122511933soppiest
sopping123917203sopping
soppy125113523sopp_y
sortie63621993sortie
soupier93111753soupier
stopple1156583stopple
supple10410203supple
tawpie11339143tawpie
tippier113210543tippier
tipple103411913tipple
toonie63617993toonie
tope65946383to_p_e
topee76029953to_pee
tophe106718973to_phe
tophi105215303tophi_
topi67830393to_pi_
topic95721503to_pic
topis76025833to_pis
topline92313183topline
topoi76018353topoi_
topped114617723topped
topper103817603topper
topping123514623topping
toppled12348843toppled
topples113111653topples
topside1037733topside
topspin1145113topspin
torpid9310913torpid
toupee8316133toupee
towie85821873to_wie
townie93312303townie
uppile10178503_uppile
vogie95116663vo_gie
weepie11258793weepie
whoopie15295933whoopie
woodie103513613woodie
woolie93514483woolie
yippee132810743yippee
yippies14279293yippies
yowie114616453yo_wie
yuppies14339263yuppies
zappier20458373zappier
zippier20308193zippier
zombie1937323zombie
zowie174313843zo_wie

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.356501941.0
2DLD Change Limit1127163044.62624365.8
3Display Results3043040.1102763.6
 (SQL Overall)1786913045.09235092.5
 
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.