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

186 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
uphold1212690(None) 
upfold12124951upfold
upheld12115561upheld
upholds13135241upholds
ahold94714252_ahold
behold1247342behold
ephod1139122epho_d
hold86235062__hold
unfold10179702unfold
unholy1238162unholy
unhood1039232unhood
unmold9148312unmold
unsold71410512unsold
untold7149682untold
upfolds13133752upfolds
uphill11106172uphill
uphoard1344572uphoard
upholder1444082upholder
uphove1436132uphove
upload9257782upload
acold86214933_acold
aholds10469483_aholds
aphid115515393aph_id
apod78123183ap_o_d
beheld1236413beheld
beholds1336423beholds
bifold1237223bifold
bold75432813__bold
child114516223_child
chola104718033_chola
cholo105217973_cholo
chord115917263_chord
cold77338773__cold
copyhold1953293copyhold
cuckold1643723cuckold
cupola10317693cup_ola
dhole95215363_dhole
echoed125211163echoed
enfold10137613enfold
ephods1238363ephods
ephor10310013epho_r
ephori1139603ephori
ephors11311403ephors
euphony1545403euphony
euploid1038963euploid
fold86528943__fold
gold65430163__gold
held85330403__held
hod76852473__ho_d
hoed87837983__hoed
holds94623243__holds
hole77553393__hole
holed95634133__holed
holk116027943__holk
holm95628113__holm
holp95727553__holp
hols76946293__hols
holt77852583__holt
holy106333433__holy
hood85132333__hood
infold10128163infold
kobold1365963kobold
mold76034333__mold
mudhole1344913mudhole
old47033473___old
opioid9310083opioid
outsold8109073outsold
outtold8107603outtold
phlox1737333_phlox
phon95925383_pho_n
phone105621933_phone
phoned124014553_phoned
phono104917023_phono
phons105221143_phons
phony136715443_phony
phot95534363_pho_t
photo104417233_photo
phots105418503_phots
phyla13469183_phyla
phyle134111153_phyle
plod76723273_plo_d
pod66351493_p_o_d
pol56449383_p_ol_
pole65951303_p_ole
poled84934843_p_oled
poll66332133_p_oll
polo66236633_p_olo
pols66044563_p_ols
poly96235153_p_oly
pond75530493_p_ond
pood75934323_p_ood
pooed85226243_pooed
pool65835953_pool_
pooled94619813_pooled
pools74427703_pools
prod76129503_pro_d
prole74527793_prole
proud84615483_proud
pyoid11513763_pyoid
refold103812113refold
remold93412973remold
resold73915363resold
retold73013753retold
scold85414863_scold
shod86225063_sho_d
shoed95723013_shoed
should1038033_should
sold54837413__sold
spool75219043spool_
spooled104613523spooled
spools85115913spools
taphole1239773taphole
thole85620843_thole
tholed105113873_tholed
toehold1146573toehold
told56132203__told
typhoid1648133typhoid
unbolt83013893unbolt
unfolds11146803unfolds
unfond10149113unfond
unhand10410383unhand
unhelm1136863unhelm
unhoods1137503unhoods
unhook1347523unhook
unhoped13249353unhoped
unload73010803unload
unmolds10135743unmolds
unroll61210073unroll
unshod1067603unsho_d
unsolid8138373unsolid
upbind11246313upbind
upboil1096453upboil
upboiled13194853upboiled
upboils1184703upboils
upbore10247883upbore
upbound12134813upbound
upbow1245613upbo_w
upbows1384683upbows
upbuild1243003upbuild
upcoil10126193upcoil
upcoiled13215183upcoiled
upcoils1184933upcoils
updo76712893updo__
updos8389513updo_s
updove1234483updove
upend85011043up_end
upfield1343033upfield
upflow1433523upflow
upfolded1542883upfolded
upgird10103933upgird
upheap13105213upheap
uphills1295233uphills
uphoards1443763uphoards
upholders1543643upholders
upholding1643373upholding
uphroe1136083uphroe
uphroes1236303uphroes
upland938863upland
uploads10266503uploads
upmost1068193upmost
upo58925863up_o__
upon65817583up_o_n
upped103715163up_ped
uppile10178503uppile
uppiled12216593uppiled
uproar8106933uproar
uproot8314123uproot
uprose82311483uprose
upsend9356883upsend
upshoot1256693upshoot
upshot1138453upsho_t
upshots1235193upshots
upsoar8105693upsoar
upstood1044243upstood
uptalk1234653uptalk
uptilt8410803uptilt
uptore8279453uptore
uptorn8268093uptorn
uptoss836093uptoss
uptown11274963uptown
upward12147163upward
upwell11285803upwell
upwind12255823upwind
whole114418093_whole
wold85429073__wold
xiphoid2045923xiphoid

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.390458182.1
2DLD Change Limit1127161865.23321539.5
3Display Results1861860.0632952.4
 (SQL Overall)1786911865.68631426.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.