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

414 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
ptooey1134641(None) 
phooey14379231phooey
blooey115110792blooey
cooey105828222_cooey
flooey123910172flooey
gooey95522862_gooey
hooey114926602_hooey
looey84822912_looey
phoney143612982phoney
pogey116017892p_ogey
pokey145318972p_okey
pooed85226242p_ooed
poofy136213272p_oofy
ptoses83514672ptoses
sooey84522432_sooey
stogey105811542stogey
stoney96217352stoney
storey95217612storey
toney86027412_toney
zooey173914802_zooey
atomy107415193at_omy
atone56527983atone_
atoned75417543atoned
atoner64817193atoner
atones65225773atones
atony87218853at_ony
atopy106813393at_opy
bloody124710173bloody
bloomy134510113bloomy
bogey115220233_bogey
boney105227313_boney
booby125319513_booby
boody115420403_boody
booed85127273_booed
boogey124711523boogey
boogy114518323_boogy
boomy125421823_boomy
booty106125913_booty
boozy194917063_boozy
broody124510083broody
broomy13449953broomy
chokey184811713chokey
choosey15459233choosey
choosy14459103choosy
coney105932883_coney
cooed84534343_cooed
cooee74531023_cooee
cooer74831013_cooer
cooeys114914483_cooeys
cookey155414333cookey
cooky145321363_cooky
cooly105525423_cooly
cosey106226713_cosey
covey136121783_covey
cozey196718543_cozey
dhooly13457143dhooly
dogey105719513_dogey
doody105517913_doody
dooly94821803_dooly
doomy116018263_doomy
doozy186813713_doozy
dopey116020353_dopey
drooly104911073drooly
droopy12458243droopy
echoey14397853echoey
ethoxy1933923ethoxy
floosy12368153floosy
floozy21356613floozy
fogey125617873_fogey
foley115222303_foley
footy115820533_footy
gloomy12528763gloomy
goody105620393_goody
goofy124915623_goofy
gooky135818033_gooky
gooney106612313gooney
goony95519783_goony
goopy115816623_goopy
goosey105913513goosey
goosy96018883_goosy
groovy13375403groovy
hokey155422183_hokey
holey115626903_holey
homey135924843_homey
honey115629913_honey
hoody124919723_hoody
hooeys125512313_hooeys
hookey164713933hookey
hooky155220263_hooky
hooly115022223_hooly
hooty115022433_hooty
hosey116127023_hosey
joey145719333__joey
jokey195014693_jokey
kooky114412873_kooky
looby108115623_looby
looed64626133_looed
looeys95110123_looeys
looney94712413looney
loony86918963_loony
loopy105316643_loopy
money104826843_money
moody115017493_moody
mooed85123983_mooed
mooley11311633mooley
moony104818273_moony
moory105115793_moory
mopey124821823_mopey
mosey105922873_mosey
motey105922953_motey
motley1139383motley
nooky124814813_nooky
nosey85619883_nosey
obey96521303__obey
oozy167018133__oozy
otology11308743otology
pacey126720283p_acey
parley116718353parley
parody12410093parody
peavey14398793peavey
pekoe114612363pekoe_
pekoes124410423pekoes
peones83821043peones
peony105717563p_eony
peroxy1838243peroxy
phloem1335703phloem
phone105621933phone_
phoned124014553phoned
phones114121213phones
phoneys15437143phoneys
phony136715443p_hony
phoresy1534653phoresy
photoed1338903photoed
piney105727503p_iney
pinkey154314673pinkey
piolet83225643piolet
ploidy1237483ploidy
plotty11208853plotty
plover115312613plover
plowed124213203plowed
plower114315063plower
ploy96123603p_lo_y
ployed124310563ployed
poboy121612223p_oboy
pocky165314603p_ocky
podgy125610773p_odgy
poem86225773p__oem
poesy105014063p_oesy
poet65552903p__oet
pogeys124110353p_ogeys
pogy105623553p__ogy
poke105335363p_oke_
poked125425393p_oked
poker115122883p_oker
pokes116133013p_okes
pokeys15529513p_okeys
poky135922153p__oky
pole65951303p_ole_
poled84934843p_oled
poler74431793p_oler
poles75351003p_oles
poleyn1157323p_oleyn
poly96235153p__oly
pome85636693p_ome_
pomes94833933p_omes
pommy14449863p_ommy
pone65747533p_one_
pones74547043p_ones
pony96434053p__ony
poo57757113p_oo__
pooch124815303p_ooch
pood75934323p_oo_d
poods85124753p_oods
poof95541663p_oo_f
poofs105222793p_oofs
pooh96027383p_oo_h
poohed123912523poohed
poohs103915713p_oohs
pool65835953p_oo_l
pooled94619813pooled
pooler83819843pooler
pools74427703p_ools
poon67341263p_oo_n
poons75430973p_oons
poop86532813p_oo_p
pooped113915943pooped
poops94422413p_oops
poor65630223p_oo_r
poorer82613993poorer
poori74816233p_oori
poorly1137893poorly
poos65949113p_oo_s
poove104514303p_oove
pooves113914713pooves
pope85535613p_ope_
popery134511703p_opery
popes95933813p_opes
poppy114813193p_oppy
popsy125713403p_opsy
pore66451263p_ore_
pored85234513p_ored
pores75849033p_ores
porgy116916123p_orgy
porky145019333p_orky
porny106020193p_orny
pose66441733p_ose_
posed85828413p_osed
poser75128773p_oser
poses74642763p_oses
posy96028423p__osy
potboy1397813potboy
poteen83514263poteen
pother113818853pother
potmen102713093potmen
potsy105815613p_otsy
potted94624013potted
potter83926983potter
pottery123011073pottery
potty105621003p_otty
potzer174411203potzer
pouty107018813p_outy
power105325953p_ower
poxed154817863p_oxed
poxes145325723p_oxes
poxy166820893p__oxy
prey96228483p__rey
pricey134412633pricey
priory114110263priory
probe94320813probe_
probed114114823probed
prober104516073prober
probes104119453probes
proem94818273p_roem
progeny1389463progeny
projet15315183projet
prole74527793prole_
proleg94612113proleg
proles84627203proles
promoed12310083promoed
prone75332623prone_
pronely12310243pronely
proof105221533proo_f
proofed13138723proofed
proofer12149103proofer
proofs114511683proofs
propel103714063propel
proper104319953proper
prose75835123prose_
prosed94921093prosed
proser84223463proser
proses84733473proses
prosody1336433prosody
prosy106319253p_rosy
protea82214763protea
protei82615303protei
prove104823193prove_
proved125016033proved
proven114314773proven
prover113819723prover
proves114322253proves
prower114218123prower
proxy175011013p_roxy
psoae74411623psoae_
ptosis83611823ptosis
ptotic102713363ptotic
pulley113713403pulley
punkey154011173punkey
purvey14559573purvey
pusley11379613pusley
pyoses114314303pyoses
rooky126117623_rooky
roomy107118063_roomy
rooty86423023_rooty
ropey106021873_ropey
shooed103916073shooed
smokey15398653smokey
snoopy11449473snoopy
snooty94211503snooty
snoozy18517223snoozy
sooty84924833_sooty
spoofy14498553spoofy
spooky15418093spooky
spooney12418243spooney
spoony114111793spoony
stagey105915583stagey
stey76224413st__ey
stoae55024263stoae_
stocky15369153stocky
stodgy11415733stodgy
stogeys11486123stogeys
stogy95414083st_ogy
stoke94922513stoke_
stoked114718293stoked
stoker104417623stoker
stokes104821793stokes
stole54928813stole_
stoled74521593stoled
stolen64315063stolen
stoles63927673stoles
stone55431183stone_
stoned75923143stoned
stoner65823203stoner
stones65130033stones
stony85818643st_ony
stood65517713stoo_d
stooge73811663stooge
stooged94310733stooged
stooges83611483stooges
stook95218213stoo_k
stooked124312303stooked
stooker113811733stooker
stooks105115373stooks
stool55619893stoo_l
stooled84313893stooled
stools65117023stools
stoop75821543stoo_p
stooped103813833stooped
stooper93813183stooper
stoops85917893stoops
stope74727243stope_
stoped94721013stoped
stoper84320093stoper
stopes84525893stopes
store56333813store_
stored75524213stored
storer64721673storer
stores65533643stores
storeys10559653storeys
stormy115510723stormy
story86723033st_ory
stoury9529943stoury
stove85220253stove_
stover94115643stover
stoves93818923stoves
stowed105817203stowed
stroy87720393stro_y
swoony12408263swoony
swoopy14487283swoopy
they107223753_t_hey
toady96814343_toady
toby96322293_t_oby
today96416953_today
toddy106812423_toddy
tody86327213_t_ody
toe310166853_t_oe_
toea46732333_t_oea
toed56137043_t_oed
toes46956443_t_oes
toffy145310283_toffy
tokay125513053_tokay
toke86738493_toke_
toked105626493_toked
token95419313_token
toker95924913_toker
tokes95234973_tokes
tole46052903_tole_
toled65934923_toled
toles55147133_toles
tome67543193_tome_
tomes76037383_tomes
tommy124712233_tommy
tone46953743_tone_
toned65435343_toned
toner55336243_toner
tones56048663_tones
tony75635153_t_ony
too38965423_too__
took86531073_too_k
tool46735683_too_l
tooled74918903_tooled
tooler63818613_tooler
tools55325243_tools
toom66532933_too_m
toon47740633_too_n
toons55027533_toons
toot45958883_too_t
tooted74620123_tooted
tooter64420803_tooter
tooth88020183_tooth
toothy12529693_toothy
toots55331873_toots
tootsy9437983_tootsy
tope65946383_tope_
toped85631313_toped
topee76029953_topee
toper75231023_toper
topes76941763_topes
tore47359323_tore_
tores55352673_tores
tory75840543_t_ory
tote46643673_tote_
toted64929483_toted
totem74819363_totem
toter55932133_toter
totes55139683_totes
towed95134583_towed
towel84920523_towel
tower85729203_tower
towery124012093_towery
towny116114493_towny
towy105325473_t_owy
toy69655193_t_o_y
toyed96019803_toyed
toyer84521553_toyer
trey77228793_t_rey
troy77429683_tro_y
typey135511883_typey
uptore8279453uptore_
woody125116883_woody
wooed94419873_wooed
wooer84316693_wooer
wooly114417673_wooly
woozy204410603_woozy
zooty175415353_zooty

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164145.82619347.1
3Display Results4144140.1562653.8
 (SQL Overall)1786914146.12229188.3
 
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.