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

135 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
phut9692597(None) 
bhut95425711bhut
hut66457291_hut
phat95837861phat
phot95534361phot
pht86030521ph_t
phuts104613501phuts
pout65752551pout
put55759071p_ut
shut76137591shut
abut66834952abut
bhuts105812952bhuts
bout66353292bout
brut66537962brut
but55963022_but
chat95546132chat
chit96937462chit
chub115516412chub
chug105914112chug
chum116318002chum
chute104316462chute
cut57957662_cut
daut56443562daut
dhuti937542dhuti
ghat86435282ghat
ghaut95919432ghaut
glut56331292glut
gout56646002gout
gut46753852_gut
hat67289962_hat
haut75949732haut
het67674312_het
hit66569192_hit
hot67776062_hot
hub86437482_hub
hue66642302_hue
hug76037362_hug
huh96432012_huh
hum85542932_hum
hun65844712_hun
hunt76445492_hunt
hup86437812_hup
hurt77142572_hurt
huts76737442_huts
jut105944012_jut
khat116730722khat
khet116328622khet
lout45952142lout
maut65448452maut
mut58357182_mut
nut36651962_nut
out38072152_out
pact86648722pact
pant66061262pant
part65967462part
past65959012past
pat58089462p_at
peat65967932peat
pelt67651082pelt
pent66559072pent
pert66759322pert
pest65555292pest
pet56477302p_et
pfft12311882pfft
pfui9349792pfui
phew128417112phew
phi86524202ph_i
phis95724902phis
phiz186718842phiz
phon95925382phon
photo104417232photo
phots105418502phots
phpht1538062phpht
pint66963172pint
pit56471922p_it
piu56639542piu_
plat66048872plat
plot66141232plot
plug74915992plug
plum85122102plum
plus66324832plus
poet65552902poet
port66059632port
post67953362post
pot58078432p_ot
pouf95732642pouf
poult76928872poult
pour611527472pour
pouts75530322pouts
pouty107018812pouty
prat65952042prat
pruta7314242pruta
psst66118402psst
pst57932512p_st
ptui64912482ptui
pub76037692p_ub
pud65836652p_ud
pug65337182p_ug
pul56138062p_ul
pun58846512p_un
punt65747202punt
pup76339882p_up
pur56840552p_ur
pus55547842p_us
puts65641752p_uts
putt66937842putt
putz158326322p_utz
rhus75114052rhus
rout46153282rout
rut35560522_rut
scut65835542scut
shat76456602shat
shit76745942shit
shot76150262shot
shout85433172shout
shul75823152shul
shun75122772shun
shunt85226512shunt
shute84520352shute
shuts85622482shuts
slut45040592slut
smut66629782smut
spout75029632spout
taut47048962taut
that75639322that
thud85613912thud
thug86415482thug
thus76721472thus
tout46753822tout
tut36758092_tut
ut28647032__ut
what105434072what
whet105133782whet
whit104834172whit
whup125714162whup

Search took 1 second 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.0762351197.4
2DLD Change Limit298721350.81336742.9
3Display Results1351350.0304500.0
 (SQL Overall)1786911350.919194440.7
 
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.