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

193 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
phot9553436(None) 
hot67776061_hot
phat95837861phat
phon95925381phon
photo104417231photo
phots105418501phots
pht86030521ph_t
phut96925971phut
plot66141231plot
pot58078431p_ot
shot76150261shot
ahoy101919182ahoy
bhoot104322102bhoot
bhut95425712bhut
blot65842322blot
boot67759372boot
bot59680402_bot
chat95546132chat
chit96937462chit
chon96627792chon
chop116024922chop
chott103923932chott
chow125820992chow
clot66542422clot
coot67860382coot
cot510483222_cot
dhoti9310122dhoti
dhow116614002dhow
dot47573182_dot
ephod1139122ephod
ephor10310012ephor
foot76248012foot
ghat86435282ghat
ghost96318762ghost
got49870442_got
grot55942052grot
hat67289962_hat
het67674312_het
hit66569192_hit
ho510258272_ho_
hob87550922_hob
hod76852462_hod
hoe67562722_hoe
hog78049062_hog
holt77852582_holt
hon67759382_hon
hoot75752102hoot
hop87554592_hop
hos68364192_hos
host77852832_host
hots78349332_hots
how97252432_how
hoy97447912_hoy
hut66457292_hut
jot108259022_jot
khat116730722khat
khet116328622khet
knot85630502knot
loot46955822loot
lot38179262_lot
mho86624622mho_
mhos95517772mhos
moot67653622moot
mot57279422_mot
not39474662_not
oho66534382oho_
oot311274692_oot
pact86648722pact
pant66061262pant
part65967462part
past65959012past
pat58089462p_at
peat65967932peat
pelt67651082pelt
pent66559072pent
peon65635242peon
pert66759322pert
pest65555292pest
pet56477302p_et
pfft12311882pfft
phew128417112phew
phi86524202ph_i
phis95724902phis
phiz186718842phiz
phlox1737332phlox
phone105621932phone
phono104917022phono
phons105221142phons
phony136715442phony
photic133316442photic
photog12379812photog
photon1111514832photon
photos113316642photos
phpht1538062phpht
phuts104613502phuts
picot95031012picot
pilot77435062pilot
pinot78737292pinot
pint66963172pint
pion67235292pion
pit56471922p_it
pivot106523872pivot
plat66048872plat
plod76723272plod
plop86625742plop
plots75025672plots
plotz164617002plotz
plow95923232plow
ploy96123602ploy
pod66351482p_od
poet65552902poet
poh86740532p_oh
poi57244662p_oi
pol56449382p_ol
pom78249912p_om
poo57757112p_oo
pood75934322pood
poof95541662poof
pooh96027382pooh
pool65835952pool
poon67341262poon
poop86532812poop
poor65630222poor
poos65949112poos
pop76252252p_op
port66059632port
post67953362post
pots66452362p_ots
pout65752552pout
pow87147282p_ow
pox126140692p_ox
prat65952042prat
pro55837262pro_
proa66229962proa
prod76129502prod
prof96134662prof
prog75729002prog
prom87631702prom
prop85932812prop
pros65742782pros
prost75434102prost
prow97030382prow
psst66118402psst
pst57932512p_st
punt65747202punt
put55759072p_ut
putt66937842putt
rho65924832rho_
rhos76319062rhos
riot45947212riot
root45655922root
rot37282952_rot
ryot75528562ryot
scot66242612scot
shat76456602shat
shit76745942shit
shoat85633952shoat
shod86225062shod
shoe75933442shoe
shog86025142shog
shoo75929892shoo
shoot84235912shoot
shop95629842shop
short85040532short
shote85526102shote
shots84730852shots
shott85332192shott
shout85433172shout
show106229192show
shut76137592shut
slot46049832slot
snot44745452snot
soot45761062soot
sot310384302_sot
spot65540692spot
stot46347332stot
swot75134662swot
that75639322that
tho67433962tho_
thou76722212thou
toot45958882toot
tot38884772_tot
trot46351312trot
upshot1138452upshot
what105434072what
whet105133782whet
whit104834172whit
who95526772who_
whoa106615202whoa
whom127018182whom
whop125520922whop
whort114623692whort
wot610467482_wot

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.263679433.5
2DLD Change Limit298721930.84635309.7
3Display Results1931930.0464195.7
 (SQL Overall)1786911931.155154710.8
 
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.