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

290 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
phpht153806(None) 
phat95837862ph_at
phot95534362ph_ot
pht86030522__pht
phut96925972ph_ut
pipet95533322pipet
pipit95224872pipit
alpha1049653alpha
aphtha1444483aphtha
apt57352543_ap_t
aught95120703aught
baht96740013_baht
bhoot104322103bhoot
bhut95425713bh_ut
bight118728843bight
caph116623293caph_
caphs124515373caphs
caput9823983caput
chant105932693chant
chapt125827643chapt
chart105038283chart
chat95546133ch_at
cheat105732453cheat
chert105232103chert
chest104926143chest
cheth135013823cheth
chit96937463ch_it
chott103923933chott
depot85727923depot
depth114311853depth
dight104027003dight
dipt77339323dip_t
echt95722903_echt
eight94928053eight
epha9310053_epha
ephah1337063ephah_
ephahs1435503ephahs
expat14313813expat
fight124027093fight
ghast95621223ghast
ghat86435283gh_at
ghaut95919433ghaut
ghost96318763ghost
haet75659503_haet
haft105941843_haft
hah910655223_hah_
haha107821063_haha
hahs108333363_hahs
halt76056303_halt
hant75461593_hant
hart76865773_hart
hast76259483_hast
hat67289963_h_at
hath105933913_hath
haut75949733_haut
heat77061423_heat
heft106736293_heft
heh96039623_heh_
hehs106723963_hehs
hent76656383_hent
hest75950773_hest
het67674313_h_et
heth107028023_heth
hight125327233hight
hilt75850713_hilt
hint77455743_hint
hist76551543_hist
hit66569193_h_it
holt77852583_holt
hoot75752103_hoot
host77852833_host
hot67776063_h_ot
huh96432013_huh_
hunt76445493_hunt
hurt77142573_hurt
hut66457293_h_ut
hypha1637383hypha
input7314653input
kaph135815753kaph_
kaphs144911503kaphs
kaput11717063kaput
kept106232943kep_t
khaph17395963khaph_
khaphs18394323khaphs
khat116730723kh_at
khet116328623kh_et
kheth15509753kheth
klepht1535043klepht
koph135816543koph_
kophs145010933kophs
lept66440883lep_t
licht104723493licht
light94429603light
might113827083might
night94327853night
opt57545543_op_t
ought95221533ought
ouph95618373ouph_
ouphe104413263ouphe
ouphs104311273ouphs
pacha126518063pacha
pact86648723p_act
pah88853593p_ah_
paint75443693paint
palet74650803palet
pant66061263p_ant
pap76758403pap__
papa85827143pap_a
papal95820673papal
papas94927493papas
papaw125112493papaw
paper95128663paper
papist102618753papist
pappi84810893pappi
pappy114713803pappy
paps86443453pap_s
part65967463p_art
pash95638133pash_
pasha105417183pasha
past65959013p_ast
pat58089463__pat
path99134913path_
paths105521383paths
peart76440753peart
peat65967933p_eat
pech116125453pech_
pechs125516203pechs
peh86740963p_eh_
pehs95625763p_ehs
pelt67651083p_elt
pent66559073p_ent
pep76447083pep__
pepla9312863pepla
pepo87622153pep_o
pepos96620083pepos
peppy114310363peppy
peps85134513pep_s
pert66759323p_ert
pest65555293p_est
pet56477303__pet
petit74332653petit
pewit104622793pewit
pfft12311883p_fft
phage115113673phage
phase104617213phase
phew128417113ph_ew
phi86524203__phi
phial10313203phial
phis95724903ph_is
phiz186718843ph_iz
phlox1737333phlox
phon95925383ph_on
phone105621933phone
phono104917023phono
phons105221143phons
phony136715443phony
photo104417233photo
phots105418503phots
phuts104613503phuts
phyla13469183phyla
phyle134111153phyle
picot95031013picot
pilot77435063pilot
pinot78737293pinot
pint66963173p_int
pip78051043pip__
pipal95118353pipal
pipe86434433pip_e
piped105123163piped
piper96523193piper
pipes96030143pipes
pipets105714773pipets
pipits104713063pipits
pips85837133pip_s
pipy115421513pip_y
pish96127913pish_
pit56471923__pit
pith95432693pith_
piths105817543piths
pithy135614463pithy
pivot106523873pivot
plait75631573plait
plant75437113plant
plat66048873p_lat
pleat74734473pleat
plight123513363plight
plot66141233p_lot
poet65552903p_oet
poh86740533p_oh_
point75338733point
pooh96027383pooh_
poohs103915713poohs
pop76252253pop__
pope85535613pop_e
popes95933813popes
poppa8409893poppa
poppet92717323poppet
poppy114813193poppy
pops86340953pop_s
popsy125713403popsy
port66059633p_ort
posh95427323posh_
posit75833333posit
post67953363p_ost
pot58078433__pot
poult76928873poult
pout65752553p_out
prahu105013973prahu
prat65952043p_rat
prest75736353prest
print74837463print
prophet14316033prophet
prost75434103prost
psst66118403p_sst
pst57932513__pst
pugh106619233pugh_
pulpit10310933pulpit
punt65747203p_unt
pup76339883pup__
pupa85422813pup_a
pupae96515643pupae
pupal97616873pupal
pupas95219283pupas
pupate104213123pupate
pupil94712983pupil
puppet93514593puppet
puppy114912413puppy
pups86032233pup_s
pupu87620713pup_u
pupus94614043pupus
push95526623push_
pushy134614353pushy
put55759073__put
putt66937843p_utt
qoph185911943qoph_
qophs19507813qophs
raphe104916423raphe
rapt67245313rap_t
repot75132623repot
rhaphe1433423rhaphe
right94430503right
sept65844363sep_t
shaft115725273shaft
shah105627783shah_
shahs115919513shahs
shalt85534493shalt
shat76456603sh_at
sheet84836963sheet
shent85933503shent
shh97121073sh_h_
shift114225143shift
shirt84533903shirt
shist84829613shist
shit76745943sh_it
shoat85633953shoat
shoot84235913shoot
short85040533short
shot76150263sh_ot
shott85332193shott
shout85433173shout
shunt85226513shunt
shut76137593sh_ut
sight94629293sight
soph97024203soph_
sophs104916023sophs
sophy136611763sophy
spat66548523_spat
spit65545083_spit
spot65540693_spot
syph125413273syph_
syphs13519453syphs
that75639323th_at
theft114118133theft
tight93626503tight
toph96326873toph_
tophe106718973tophe
tophi105215303tophi
tophs105220053tophs
wecht13415443wecht
wept95635053wep_t
what105434073wh_at
wheat114924573wheat
whet105133783wh_et
whipt135317423whipt
whisht154510813whisht
whist115322953whist
whit104834173wh_it
whort114623693whort
wight123725573wight
yacht13417393yacht

Search took 4 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 Filter178691836670.343520965.0
2DLD Change Limit836672903.54623594.8
3Display Results2902900.0763815.8
 (SQL Overall)1786912903.96545067.1
 
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.