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 “poky” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

216 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
poky13592215(None) 
coky137526821coky
joky186215311joky
pocky165314601pocky
pogy105623551pogy
poke105335361poke
pokey145318971pokey
poly96235151poly
pony96434051pony
porky145019331porky
posy96028421posy
poxy166820891poxy
alky115920342alky
body107425672body
bogy106426192bogy
bony96732082bony
bosky145612392bosky
boxy166420732boxy
boy87753562bo_y
caky136222442caky
choky175711222choky
cocky164215932cocky
coke107038382coke
coly96940532coly
conky145818742conky
cony96537832cony
cooky145321362cooky
copy116229802copy
corky145221152corky
cory96941512cory
cosy97232702cosy
cowy126427362cowy
coy810557552co_y
cozy185823802cozy
doby106022162doby
dogy96126492dogy
dopy106224152dopy
dorky135518742dorky
dory85836232dory
doty86128222doty
doxy156419952doxy
dozy175920322dozy
epoxy17465772epoxy
fogy115923182fogy
folky159214712folky
forky156119642forky
foxy176517752foxy
foy96044262fo_y
fozy197017162fozy
goby106021082goby
gooky135818032gooky
gory86129662gory
goy77844552go_y
hoke115935932hoke
hokey155422182hokey
holy106333432holy
homy126623222homy
honky156218522honky
hooky155220262hooky
hoy97447912ho_y
icky136315752icky
inky115321582inky
joey145719332joey
joke155926162joke
jokey195014692jokey
joy137036362jo_y
kooky114412872kooky
laky116725822laky
logy87025782logy
lory75931712lory
moke106234222moke
moly96031912moly
mony96830012mony
mopy115721972mopy
nooky124814812nooky
nosy76322892nosy
oaky116419952oaky
oka76926802_oka
okay115917662_okay
oke75839482_oke
oozy167018132oozy
oxy136320982_oxy
oy58950132_o_y
pacy115328682pacy
paly95835532paly
paty95234562paty
pawky173810152pawky
pay88461182p_ay
peaky145718152peaky
pecky165515092pecky
peke105926202peke
peony105717562peony
perky145319482perky
pesky145911562pesky
phony136715442phony
picky165416942picky
pika106322952pika
pike106335212pike
piki106520562piki
pily96132732pily
pinky145823402pinky
piny911838352piny
pipy115421512pipy
pity96031932pity
pixy166117762pixy
play95928982play
ploy96123602ploy
ply86323552p_ly
poboy121612222poboy
pock126129292pock
pocks135022962pocks
poco86826152poco
pod66351482po_d
podgy125610772podgy
pods76540152pods
poem86225772poem
poesy105014062poesy
poet65552902poet
pogey116017892pogey
poh86740532po_h
poi57244662po_i
pois66539042pois
poked125425392poked
poker115122882poker
pokes116133012pokes
pokeys15529512pokeys
pokily15309062pokily
pol56449382po_l
pole65951302pole
polka11310412polka
poll66332132poll
polo66236632polo
pols66044562pols
polyp125611532polyp
polys105718762polys
pom78249912po_m
pome85636692pome
pommy14449862pommy
pomo85828452pomo
pomp106225462pomp
poms87037742poms
pond75530492pond
pone65747532pone
pong76231142pong
pons65850602pons
poo57757112po_o
pood75934322pood
poof95541662poof
poofy136213272poofy
pooh96027382pooh
pool65835952pool
poon67341262poon
poop86532812poop
poor65630222poor
poos65949112poos
pop76252252po_p
pope85535612pope
poppy114813192poppy
pops86340952pops
popsy125713402popsy
pore66451262pore
porgy116916122porgy
pork106929682pork
porks115124142porks
porn65636022porn
porny106020192porny
port66059632port
pose66441732pose
posh95427322posh
post67953362post
pot58078432po_t
pots66452362pots
potsy105815612potsy
potty105621002potty
pouf95732642pouf
pour611527472pour
pout65752552pout
pouty107018812pouty
pow87147282po_w
pows95537662pows
pox126140692po_x
pray96331532pray
prey96228482prey
prosy106319252prosy
proxy175011012proxy
pry85728052p_ry
puke105025462puke
punky144419392punky
puny95526992puny
rocky144513852rocky
rooky126117622rooky
ropy96323412ropy
rosy76024872rosy
sky106420992_sky
smoky14388682smoky
soke85436262soke
soy67851452so_y
spiky146014112spiky
spoke114818662spoke
spooky15418092spooky
toby96322292toby
tody86327212tody
tokay125513052tokay
toke86738492toke
tony75635152tony
tory75840542tory
towy105325472towy
toy69655192to_y
wok106334172wok_
woke115527962woke
woks116224902woks
wonky154011772wonky
yok107335242yok_
yoke115626392yoke
yoks116223742yoks
yolky15529522yolky

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298722161.00029872.0
3Display Results2162160.0464695.7
 (SQL Overall)1786912161.326134759.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.