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

406 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
poetry113938(None) 
paltry114910402paltry
pantry115014102pantry
pastry114913032pastry
peery105719442p_eery
peltry11288652peltry
perry105222712p_erry
petty105320292p_etty
piety105817302piet_y
poesy105014062poe_sy
poet65552902poet__
poetic10416842poetic
poets76024442poet_s
popery134511702popery
portly114713402portly
portray1237482portray
potsy105815612po_tsy
pottery123011072pottery
potty105621002po_tty
poultry1235382poultry
pouty107018812pout_y
poverty1536432poverty
predry1237862predry
pretty11510872pretty
retry84718082_retry
aery77231683_ae_ry
agentry11165753agentry
apery106517903ape_ry
artery9911453artery
aweary1237303aweary
beery105220123_beery
berry104521773_berry
betray111511443_betray
biometry1546183biometry
bleary115112553bleary
bootery1238983bootery
booty106125913boot_y
borty105522833bort_y
bothy136713963bo_thy
bowery146012113bowery
cheery144913153cheery
cherry144810763cherry
cherty144612473cherty
cometary1547693cometary
contra83314693contra
coquetry2243553coquetry
corsetry1365563corsetry
cory96941513co__ry
costly114012333costly
country12388033country
covary1438743covary
cowry135512483co_wry
deary95826843_deary
decry115514353_decry
derry94721373_derry
dietary1158663dietary
doer57734703doe_r_
doers65225713doe_rs
doeth9411983doet_h
dorty96220813dort_y
dory85836233do__ry
doter65428623doter_
doters74423913doters
dotty94516103do_tty
doty86128223do_t_y
dowery134311663dowery
dowry126312483do_wry
dreary104611673dreary
eatery95316353eatery
eery76129623__eery
emery104814333eme_ry
entry82414263_entry
every115215453eve_ry
eyry106315883__eyry
faery116015483fae_ry
ferry116020803_ferry
fiery114714793fie_ry
fleury12417353fleury
foetal9311883foetal
foetid10510513foetid
foetor939563foetor
foetors1039753foetors
foetus958523foetus
footsy12587933footsy
footy115820533foot_y
forestry1446723forestry
forty114824273fort_y
fretty1249223fretty
gantry103810113gantry
gentry103410443gentry
geometry1445393geometry
goer56827103goe_r_
goers65520253goe_rs
goitre7349003goitre
gory86129663go__ry
gouty95217363gout_y
henry114014473_henry
herry114922473_herry
hoary114516763ho_ary
hoer76533983hoe_r_
hoers85724923hoe_rs
hooty115022433hoot_y
horary12310383horary
hostly124210863hostly
hotly115815473ho_tly
isometry1346113isometry
jerry155016183_jerry
jetty156212583_jetty
joey145719333joe__y
jolty155713033jolt_y
jotty155012603jo_tty
kerry124916093_kerry
leary85927383_leary
leery85919133_leery
lofty115813303loft_y
lorry86315673lo_rry
lory75931713lo__ry
lottery10389833lottery
loury85716753lo_ury
lowery124112713lowery
meetly1138673meetly
merry104721483_merry
metre74821303_metre
metro74718803_metro
moiety1148223moiet_y
monetary1346523monetary
moory105115793mo_ory
mopery135210973mopery
mortary12369043mortary
mostly113110943mostly
motey105922953mo_tey
mothy136214553mo_thy
mouthy14409063mouthy
netty85816763_netty
nitery94412173nitery
noetic8514043noetic
nonentry1146813nonentry
notary92310713notary
noter55025643noter_
noters64020993noters
ochry13346933_ochry
odometry1444753odometry
onery8414123_onery
openly1137123openly
opera7313573ope_ra
optometry1654453optometry
osetra667423osetra
outby10411533_outby
outcry1137993_outcry
outre53922193_outre
ovary1149113_ovary
panfry14456413panfry
panty105929303pant_y
papery134812743papery
parry105323753p_arry
partly116315473partly
party106630613part_y
pasty105725053past_y
pater74740723pater_
paters84935823paters
patly105020583p_atly
patsy105717203p_atsy
patty104723613p_atty
paty95234563p_at_y
peaky145718153p_eaky
pear69745233p_ear_
pearl75324463p_earl
pearly116414843p_early
pears75138613p_ears
peart76440753p_eart
peaty105725693p_eaty
peavy135014843p_eavy
pecky165515093p_ecky
pedro8313153p_edro
peer66238353p_eer_
peers75130273p_eers
penny105119453p_enny
penury1148103penury
peony105717563p_eony
peppy114310363p_eppy
per56353093p_e_r_
perdy115417323p_erdy
pere66450263p_e_re
peri65636973p_e_ri
perk106232843p_e_rk
perky145319483p_erky
perm85834633p_e_rm
perp89029893p_e_rp
pert66759323p_e_rt
pertly115312543pertly
perv97224813p_e_rv
pesky145911563p_esky
pesty106421713p_esty
pet56477303p_et__
petal76526893p_etal
petard95013803p_etard
peter74427593p_eter
peters86624593p_eters
petit74332653p_etit
petrel83111533p_etrel
petrify1536573p_etrify
petrol82714063p_etrol
pets66248333p_et_s
petti75119453p_etti
petto76021043p_etto
phratry1543743phratry
pier66035293pie_r_
piers75926333pie_rs
pieta75421753piet_a
pietas84516503pietas
pinery115214293pinery
pithy135614463p_ithy
pity96031933p_it_y
platy105021663plat_y
plectra1145783plectra
plenary1237543plenary
plenty11311413plenty
pleura837533pleura
plotty11208853plotty
poachy16388963poachy
poboy121612223po_boy
pocky165314603po_cky
podgy125610773po_dgy
podiatry1444343podiatry
poem86225773poe__m
poems95715553poe_ms
poetess938933poetess
poetics11312073poetics
poetise9314043poetise
poetize18310773poetize
poetries10315583poetries
pogey116017893po_gey
pogy105623553po__gy
pointy114913283pointy
poitrel936193poitrel
poker115122883poker_
pokers124617923pokers
pokey145318973po_key
pokily15309063pokily
poky135922153po__ky
polar75623453polar_
polars84419353polars
poler74431793poler_
polers84225643polers
policy133211513policy
polity113015863polity
poly96235153po__ly
pommy14449863po_mmy
pontes83627853pontes
pontil8315463pontil
ponton83217643ponton
pony96434053po__ny
poofy136213273po_ofy
poor65630223po_or_
poori74816233po_ori
poorly1137893poorly
poppy114813193po_ppy
popsy125713403po_psy
pore66451263po__re
porgy116916123po_rgy
pork106929683po__rk
porky145019333po_rky
porn65636023po__rn
porny106020193po_rny
port66059633po__rt
portal84218463portal
ported94223243ported
porter84224413porter
porters93722703porters
portrays1345293portrays
ports75934593port_s
poser75128773poser_
posers84223973posers
poseur8419403poseur_
poseurs9378283poseurs
poshly1437723poshly
post67953363post__
postal84317533postal
postboy1476673postboy
posted93722493posted
poster84129173poster
postern93615603postern
posters93927993posters
postie84123963postie
postin83521033postin
postop10511943postop
posts75228783post_s
posture9313253posture
posy96028423po__sy
pot58078433po_t__
potatory1348413potatory
potboy1397813potboy
poteen83514263poteen
potency1457433potency
potent84223353potent
potently1347403potently
pots66452363po_t_s
potted94624013potted
potter83926983potter
potters94024343potters
pottle84416103pottle
potto75320943po_tto
pottos84615873pottos
pouchy16538663pouchy
pouffy17395883pouffy
pour611527473po_ur_
pours74623183po_urs
pout65752553pout__
pouted94021393pouted
pouter83923983pouter
pouters94221863pouters
pouts75530323pout_s
powdery16396123powdery
power105325953power_
powers113822323powers
powter114116033powter
powters124015653powters
poxy166820893po__xy
prearm104512343prearm
prebuy1357423prebuy
prepay13310313prepay
preppy1235523preppy
pretax152310193pretax
preterm11310153preterm
pretor8315743pretor
pretors9316803pretors
pretrim11310773pretrim
prexy174611573pre_xy
prey96228483pre__y
priory114110263priory
proette9312363proette
proletary1445833proletary
property1547073property
pry85728053p___ry
psaltry12213803psaltry
puberty1444783puberty
puggry13374823puggry
punty106021613punt_y
puppetry1442503puppetry
purty105019403purt_y
putty104721403p_utty
pyrometry1945613pyrometry
query174212083que_ry
qwerty2133583qwerty
redry94314363_redry
reentry1038033reentry
refry114412463_refry
retro55020953_retro
robotry1244163robotry
rocketry1744503rocketry
rooty86423023root_y
ropery114313873ropery
rosary92810353rosary
rosery93813283rosery
rostra6310933rostra
rotary92411303rotary
sentry92912053sentry
serry84824123_serry
sherry124510413sherry
skerry13356103skerry
smeary114110803smeary
sneery93610413sneery
softly12457763softly
softy115414483soft_y
sooty84924833soot_y
sorry84618253so_rry
sphery14318883sphe_ry
sporty115112493sport_y
spotty11448573spo_tty
suety85318493suet_y
sultry938463sultry
sweltry1333413sweltry
teary85124053_teary
terry84721873_terry
tetra53417953_tetra
tetri52716453_tetri
tetryl935693_tetryl
theory121098353theory
toiletry1144103toiletry
toothy12529693toothy
tootsy9437983tootsy
tory75840543to__ry
toter55932133toter_
toters65026363toters
tottery10388483tottery
towery124012093towery
try66529673___try
udometry1443823udometry
veery115816253_veery
very108025643_ve_ry
vestry1238623vestry
volery1237873volery
votary12248333votary
voter85121053voter_
voters95017443voters
wastry12388773wastry
watery123914493watery
weary115620613_weary
wetly114511713_wetly
wherry15477333wherry
wintry12498923wintry
worry116114333wo_rry
worthy15598803worthy
zonary1838793zonary
zoometry2244643zoometry
zooty175415353zoot_y

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.1431249587.4
2DLD Change Limit1127164065.29621283.2
3Display Results4064060.1263222.2
 (SQL Overall)1786914065.56532109.8
 
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.