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

413 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
hopple13291048(None) 
hoppled15338081hoppled
hopples142810711hopples
popple92710981popple
topple104411321topple
apple94517672_apple
couple104415962couple
dapple1138852dapple
fipple13329062fipple
hippie132811242hippie
hirple11158972hirple
hobble133913432hobble
hole77553392ho__le
hondle103914522hondle
hoopla1147632hoopla
hoopoe11911232hoopoe
hope96639672ho_p_e
hopped144318112hopped
hopper134218482hopper
hoppier143110702hoppier
hoppy154912352hopp_y
hoyle11314412ho_yle
koppie14277882koppie
nipple103410372nipple
poppled11339242poppled
popples103011872popples
ripple103413912ripple
shoppe133110322shopp_e
stopple1156582stopple
supple10410202supple
tipple103411912tipple
toppled12348842toppled
topples113111652topples
ample94720303_ample
ampule10710613ampule
appel94615893_appel
apples104315763_apples
applet105917433_applet
apply125111393_apply
bobble94115143bobble
boggle104511943boggle
bogle85821683bo_gle
bole66448693bo__le
boodle93215033boodle
bopped134413403bopped
bopper123813833bopper
bottle84916073bottle
boucle103712783boucle
boule74828043bo_ule
boulle84614613boulle
buppie12288733buppie
chappie16298663chappie
chippie16297693chippie
chopine143512263chopine
chopped174511013chopped
chopper163611893chopper
choppier17286653choppier
choppily2044133choppily
choppy18376293chopp_y
chorale124313353chorale
chortle124210443chortle
cobble123615263cobble
coble94823173co_ble
cockle143913573cockle
coddle104713853coddle
coffle14359043coffle
cole66956113co__le
compel124412893compel
compile13312443compile
complex2037243complex
comply152810383comply
copal95621783copal_
copalm125010813copalm
copals105018943copals
cope86847383co_p_e
copped135221263copped
copper124321893copper
coppice1537483coppice
coppra12306833coppra
copse95623933co_pse
copula102812043copula
copulae112810613copulae
corpse104013413corpse
coupe96023483coup_e
coupled124312673coupled
coupler114713013coupler
couples115317053couples
couplet114717943couplet
cowpie133511513cowpie
cripple13378583cripple
croppie13278803croppie
cupule103410723cupule
dappled1336393dappled
dapples1238993dapples
dhole95215363dho__le
dimple113512793dimple
dipole91112853dipole
doable93115243doable
docile94213123docile
dole56550003do__le
dongle83612493dongle
doodle83212853doodle
dope76038893do_p_e
dopily123510463dopily
dottle74212503dottle
double94013993double
duple85315863_duple
empale102611263empale
epopee10312503epopee
fipples14298653fipples
foible11410383foible
fondle104412943fondle
footle93914383footle
foozle18369203foozle
fopped144012673fopped
gobble113512983gobble
goggle94511573goggle
gospel936533gospel
grapple12378003grapple
gripple12416613gripple
habile11515213habile
hackle154916813hackle
haggle113511983haggle
hale76052833h__ale
handle104219293handle
hantle94318203hantle
haole84820083h_aole
haply135915063h_aply
happed144820103happed
happen134812193happen
happier143312043happier
happily1745763happily
happy155813533happ_y
hassle93711593hassle
heckle153112093heckle
heddle114211163heddle
hempie132410563hempie
hepper133412663hepper
higgle113811743higgle
hiply134113613h_iply
hipped144317693hipped
hipper133818023hipper
hippier143212103hippier
hippies142813753hippies
hippo12369063hipp_o
hippos13408433hippos
hippy155112793hipp_y
hirpled13157143hirpled
hirples12149643hirples
hirsle9159573hirsle
hoagie102310013hoagie
hoarse94411323hoarse
hobbled153310783hobbled
hobbler143710403hobbler
hobbles143313783hobbles
hoe67562723ho___e
hogtie102711773hogtie
hoise85224773ho_ise
hoke115935933ho__ke
hokily16409093hokily
hold86235063ho__ld
holed95634133ho__led
holes84748653ho__les
holey115626903ho__ley
holily123612953holily
holk116027943ho__lk
holla84918493ho_lla
holler93520613ho_ller
hollo84822163ho_llo
holly114824433ho_lly
holm95628113ho__lm
holp95727553ho__lp
holpen11299413holpen
hols76946293ho__ls
holt77852583ho__lt
holy106333433ho__ly
homage121210603homage
hombre13309303hombre
home98042443ho__me
homely145313183homely
homie104622533ho_mie
homily144712333homily
hondled123510653hondled
hondles113614523hondles
hone77549323ho__ne
honkie133011673honkie
hoodie105116143hoodie
hooklet142510813hooklet
hoolie93217783hoolie
hooly115022223ho_oly
hoop96129983hoop__
hooped125518183hooped
hooper114518313hooper
hooplas1239213hooplas
hoopless13279263hoopless
hooplike1736773hooplike
hoopoes121212483hoopoes
hoopoo1198753hoopoo
hoops105621073hoop_s
hop87554593ho_p__
hoped115628183ho_ped
hopeless13118303hopeless
hoper105829143ho_per
hopers114222973hopers
hopes105835643ho_pes
hoping123719743hoping
hoplite12311073hoplite
hoppers143115143hoppers
hoppiest152610733hoppiest
hopping154115273hopping
hoppling16206763hoppling
hops97942633ho_p_s
horal86328683horal_
horde94623053ho_rde
horse86132653ho_rse
horste94817413horste
hose76547243ho__se
hosel86024823hosel_
hosels94218613hosels
hospice14117063hospice
hostel93914153hostel
hostile10312553hostile
hostler103411023hostler
hostly124210863hostly
hotel85520753hotel_
hotels94515523hotels
hotly115815483ho_tly
hottie92514383hottie
hourly12369623hourly
house89131423ho_use
housel95217053housel
hove107132223ho__ve
hovel115017683hovel_
hoveled14209293hoveled
hovels125413343hovels
howdie13349733howdie
howe106734103ho__we
howl107625693ho_wl_
howled134014973ho_wled
howler123514313ho_wler
howlet123518343ho_wlet
howls116219223ho_wls
hoyles12315013ho_yles
huckle153913073huckle
huddle113712993huddle
humble133615053humble
huppah1644183huppah
hurdle103712793hurdle
hurtle93512943hurtle
hustle93113993hustle
hype125519813h_yp_e
hyphae1746433hyphae
impale102811663impale
joggle154010353joggle
jole117233823jo__le
jostle13319863jostle
joule124918203jo_ule
kopje1835273ko_pje
koppa13397293kopp_a
koppas14407603koppas
koppies153210013koppies
lobule82910063lobule
locale83915653locale
locule83412033locule
lope65941923lo_p_e
lopped114218623lopped
lopper103717203lopper
loppier11369723loppier
loppy125911663lopp_y
loupe75319513loup_e
maple95521143_maple
mobile103613543mobile
module93011033module
mole66251833mo__le
mope86838043mo_p_e
mopoke1436633mopoke
mopped134114323mopped
mopper126215003mopper
moppet126915093moppet
morale85220553morale
motile83818343motile
mottle84116053mottle
nappe96114993napp_e
nappie104112263nappie
nippled12307643nippled
nipples11319663nipples
nobble103814313nobble
noble74420993no_ble
noddle83211363noddle
nodule7309803nodule
nonuple946153nonuple
noodle73212543noodle
nopal75517103nopal_
nopales93812523nopales
nopals84914023nopals
nope65934193no_p_e
nozzle14236633nozzle
obole75917143_obole
odyle9349593_odyle
ogle56325053_o_gle
ole37155213_o__le
opal66923523_opal_
opals75718353_opals
ope56845243_o_p_e
opine77422463_opine
oppose1039193_oppose
orle45630463_o_rle
ouphe104413263_ouphe
ovule839493_ovule
pale66055013__pale
papule102212133papule
pele65539553__pele
people10310193people
pile65649693__pile
pimple123512963pimple
pole65951303__pole
poodle93112043poodle
pope85535613po_p_e
poppa8409893popp_a
poppas93710713poppas
popped104117813popped
popper93615963popper
poppet92717323poppet
poppied11388993poppied
poppies102816203poppies
poppy114813193popp_y
popsie103013063popsie
posole8314223posole
potpie103412433potpie
pottle84416103pottle
pozole1758913pozole
pule65040953__pule
purple102712683purple
rappee103618673rappee
rappel104211953rappel
rimple103814583rimple
rippled123110273rippled
rippler113210103rippler
ripples113513293ripples
ripplet113412583ripplet
ripply13348003ripply
roble75223023ro_ble
role45851823ro__le
rootle63214453rootle
ropable111611333ropable
rope65542913ro_p_e
ropily113312443ropily
rouble83913313rouble
rumple103913013rumple
sample104215013sample
semple103212753semple
shopped153512213shopped
shopper143312633shopper
shoppes143411403shoppes
simple104315173simple
socle7419573so_cle
sole46053673so__le
sopite84917713sopite
sopped114819903sopped
soppier112711583soppier
soppy125113523sopp_y
spale74929213_spale
spile75230083_spile
staple84415823staple
stipple1146623stipple
stoppled1345003stoppled
stopples1236953stopples
suppled1248463suppled
suppler1148433suppler
supples11511283supples
supply1346893supply
swiple11379233swiple
swipple1444633swipple
temple102811333temple
thole85620843tho__le
thorpe113610093thorp_e
tippled12358393tippled
tippler11348343tippler
tipples112811253tipples
toddle85811033toddle
toggle83810873toggle
toile54626493to_ile
tole46052903to__le
tootle62613813tootle
tope65946383to_p_e
topee76029953to_pee
tophe106718973to_phe
topped114617723topped
topper103817603topper
toupee8316133toupee
tousle64514653tousle
touzle15429003touzle
triple84215923triple
unpile81914323unpile
uppile10178503uppile
voile84719723vo_ile
vole75236983vo__le
wheeple1534873wheeple
whole114418093who__le
whoopee15287523whoopee
whoopie15295933whoopie
whoopla1542633whoopla
whopped18358003whopped
whopper17328503whopper
whortle13335943whortle
wimple133611363wimple
wobble133212313wobble
yippee132810743yippee
yippie13277843yippie
yodle94515043yo_dle
yuppie13297133yuppie
zeppole2043493zeppole
zonule1577483zonule

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.373479064.3
2DLD Change Limit1127164134.78323566.0
3Display Results4134130.1233357.7
 (SQL Overall)1786914135.27933849.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.