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

244 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
popover149584(None) 
popovers1595661popovers
flopover1642862flopover
hoover124314432ho_over
opposer1135772opposer
plover115312612p_lover
pooler83819842po_oler
poorer82613992po_orer
poove104514302po_ove_
pooves113914712po_oves
popper93615962pop_per
proposer121810632proposer
prover113819722p_rover
stopover1344062stopover
allover1038583allover
apposer1147483apposer
approver15105303approver
boilover1344023boilover
booger94816553bo_oger
booker124719193bo_oker
boomer104618513bo_omer
boozer174815963bo_ozer
bopper123813833bop_per
clover114617123_clover
colorer9312523colorer
composer145012953composer
cooer74831013co_o_er
cooker124722453co_oker
cooler84824713co_oler
cooper104221123co_oper
cooter85128613co_oter
coper95336093cop__er
copier103722893cop_ier
copper124321893cop_per
copter109822013cop_ter
coroner94218203coroner
cover105430773__cover
cutover1235283cutover
deposer104011843deposer
doozer163910463do_ozer
doper86128393dop__er
dopier93515923dop_ier
drover104614593_drover
empower14217033empower
exposer1637413exposer
flopovers1742563flopovers
flyover1633513flyover
footer94320773fo_oter
forever1338953forever
glover104513533_glover
goober93911743go_ober
gooier73516213go_oier
goopier103910573goopier
gopher1239183gop_her
groover11358543groover
holdover1544083holdover
honorer1039673honorer
hoofer124014953ho_ofer
hooker134820173ho_oker
hooper114518313ho_oper
hooter94123933ho_oter
hooved134713123ho_oved
hoovers134312703ho_overs
hooves124815483ho_oves
hoper105829143hop__er
hopper134218483hop_per
hoppier143110703hoppier
hover115524133__hover
however1634513however
imposer113310103imposer
impower14247123impower
improver1545243improver
ionomer939833ionomer
kotower1434383kotower
layover1334433layover
looker104816953lo_oker
looper83817113lo_oper
loopier93711193loopier
looser65219943lo_oser
looter64222323lo_oter
loper75129233lop__er
lopper103717203lop_per
loppier11369723loppier
louver94110393lo_uver
lover85526453__lover
monomer11311893monomer
mooner85317833mo_oner
mooter83921093mo_oter
moper94925923mop__er
mopier103914783mop_ier
mopoke1436633mopoke_
mopokes1536693mopokes
mopper126215003mop_per
moreover1344863moreover
mover104220863__mover
nooser65517823no_oser
opener83910993_opener
oppose1039193oppose_
opposed1236123opposed
opposers1244973opposers
opposes1149243opposes
over77227343___over
palaver1238753palaver
paper95128663pap__er
paperer113111903paperer
pappier103511603pappier
passover13135533passover
paver104225833__paver
peopler1138083peop_ler
pepper93512943pep_per
peppier10268323peppier
piper96523193pip__er
pipier104913983pip_ier
plovers123611833p_lovers
plower114315063p_lower
poacher143912323poacher
pockier153911603pockier
pocosen1146833pocosen
podgier11338723podgier
podomere1344993podomere
pointer93814933pointer
poiser84217243po_iser
poisoner1046983poisoner
poker115122883__poker
pokier124914633po_kier
polder94019253po_lder
poler74431793__poler
policer113112683policer
politer92417073politer
poller83921853po_ller
polymer1438063polymer
ponder94521693po_nder
pooed85226243po_o_ed
poofter1237163poofter
poohed123912523po_ohed
pooled94619813po_oled
poolers94217423po_olers
pooped113915943po_oped
poor65630223po_o__r
pope85535613pop__e_
popery134511703pop__ery
popes95933813pop__es
popeyed1535713popeyed
poplar103611113pop_lar
popped104117813pop_ped
poppers103414863pop_pers
poppet92717323pop_pet
poppied11388983poppied
poppies102816203poppies
popple92710983popple_
poppled11339243poppled
popples103011873popples
popsie103013053popsie_
popsies112816463popsies
popular11319563popular
porker124917543po_rker
porkier133712343porkier
pornier93413133pornier
porose84818743porose_
porter84224413po_rter
poser75128773__poser
posher115018163po_sher
posole8314223posole_
posoles9314883posoles
poster84129173po_ster
postponer1346033postponer
pother113818853po_ther
potter83926983po_tter
pottier93516493pottier
potzer174411213po_tzer
poulter93712013poulter
pouncer113511233pouncer
pounder103314003pounder
pourer84516043po_urer
pouter83923983po_uter
poutier93215323poutier
powder123611903po_wder
power105325953__power
powter114116033po_wter
poxier153812113po_xier
pozole1758913pozole_
pozoles1839063pozoles
preaver121011613preaver
prober104516073p_rober
promoter12311453promoter
proofer12149103proofer
proper104319953p_roper
properer1259203properer
propone112716303propone_
proponed132412033proponed
propones122516963propones
propose112714843propose_
proposed132011073proposed
proposers13228523proposers
proposes122515973proposes
proser84223463p_roser
prove104823193p_rove_
proved125016033p_roved
proven114314773p_roven
proverb14378213p_roverb
provers123817793p_rovers
proves114322253p_roves
provoker1784913provoker
prower114218123p_rower
pullover13134643pullover
pushover1643083pushover
recover124312623recover
remover124612273remover
reposer93715333reposer
repower12329883repower
reprover13229203reprover
rollover1144453rollover
roofer94415283ro_ofer
roomer84718633ro_omer
rooser63921883ro_oser
rooter64926033ro_oter
roper75431913rop__er
ropier84118803rop_ier
rover85527373__rover
runover1034663runover
shover124515993_shover
slipover1343833slipover
soever94412093so_ever
solver94016703so_lver
sooner64220463so_oner
sopor74016493sopo__r
soppier112711583soppier
spoofer12368723spo_ofer
spooler93711383spo_oler
stopovers1443833stopovers
stover94115643_stover
tooler63818613to_oler
tooter64420803to_oter
toper75231023top__er
topper103817603top_per
trover95014663_trover
uncover1239003uncover
vaporer1236983vaporer
vocoder1334693vocoder
wolver12419713wo_lver
wooer84316693wo_o_er
woofer124411363wo_ofer
wooler93615873wo_oler
zooier153411233zo_oier

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.406440125.6
2DLD Change Limit1340272446.26621389.6
3Display Results2442440.0763210.5
 (SQL Overall)1786912446.74826480.6
 
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.