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

230 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
upheld1211556(None) 
uphold12126901uphold
beheld1236412beheld
held85330402__held
unhelm1136862unhelm
upend85011042up_end
upfield1343032upfield
upfold12124952upfold
upheap13105212upheap
uphill11106172uphill
upholds13135242upholds
upped103715162uppe_d
upsend9356882upsend
upwell11285792upwell
aahed917816443aahe_d
ached119227833ache_d
afield1035953afield
ahead96817053_ahead
ahed89536253_ahe_d
ahold94714253_ahold
aped78538153ap_e_d
aphelia1249423aphelia
aphid115515393aph_id
appel94615893appel_
appels104312793appels
append1138273append
ashed97829773ashe_d
behead1239923behead
behold1247343behold
bield84614653_bield
bushed124822383bushe_d
bushel114513943bushel_
busheled1465263busheled
bushels124110713bushels
bushveld1741853bushveld
cepheid1545433cepheid
chela103916803_chela
chield124610213chield
child114516223_child
cohead123811123cohead
cupel9514303cup_el_
cupeled1257793cup_eled
cupels10310203cup_els
cupped134413983cuppe_d
duped95118323dup_e_d
dupped124411643duppe_d
eched116919223eche_d
eld46733793___eld
ephebe1336063ephebe
ephebi1345083ephebi
ephod1139123eph_od
field95015323_field
fjeld16465583_fjeld
geld65828433__geld
gushed114816243gushe_d
head87137173__head
heed86437603__heed
hell75637893__hell
helm95530023__helm
helo75332853__helo
help95328923__help
herd84933063__herd
hold86235063__hold
hophead16337923hophead
humphed1835423humphe_d
hushed134416673hushe_d
jughead1933643jughead
lushed104218723lushe_d
meld75830473__meld
mohel104914833mohel_
mohels115011323mohels
mushed124420843mushe_d
ohed87825183_ohe_d
oohed94214213oohe_d
oped76230153op_e_d
opted84914273opte_d
ouched124316933ouche_d
ouphe104413263ouphe__
ouphes113614633ouphe_s
paled85538723_paled
ped66751523_p_e_d
peed76239183_p_eed
peel65535613_peel_
peeled94119703_peeled
peels75226423_peels
pele65539553_p_ele
pelf97031453_p_elf
pelt67651083_p_elt
pend75934533_p_end
phew128417113_phe_w
phyla13469183_phyla
phyle134111153_phyle
pied75035363_pie_d
piled85232993_piled
plead85818463_plead
pled75231433_ple_d
poled84934843_poled
preed85128113_preed
pseud867043_pseud
puked124716223puke_d
puled84926523pule_d
pulled94322193pulled
pumelo10257113pumelo
pupped105013273puppe_d
pureed95017803pureed
purely114013613purely
purled94520743purled
pushed125017463pushe_d
reweld103711113reweld
ruched124314633ruche_d
rushed104419863rushe_d
saphead1357773saphead
shed86536153_she_d
shelf115221113_shelf
shell84424123_shell
shend94719973_shend
sherd96321153_sherd
shield106212973shield
spaed85522273spae_d
sped76031493sp_e_d
speed85526623sp_eed
speel74420763speel_
speeled103712453speeled
speels85116393speels
spell75020303sp_ell
spelt75430193sp_elt
spend85619333sp_end
sphene113412403sphene
sphere113313653sphere
sphered133512313sphered
sphery14318883sphery
spied85427713spie_d
spiel74623913spiel_
spieled104811883spieled
spiels85317953spiels
spiled94621993spiled
spread9312533spread
spued84918473spue_d
subhead1387693subhead
sughed113610203sughe_d
supped114415703suppe_d
suppled1248463suppled
tupelo836483tup_elo
tupped114013233tuppe_d
tushed104615893tushe_d
umbel93612833umbel_
umbeled12208193umbeled
umbels104510583umbels
umped104717273umpe_d
unbelt83015693unbelt
unbend9269773unbend
undead82711903undead
unfed94614223unfe_d
unfelt92413463unfelt
unfold10179703unfold
unhand10410383unhand
unhealed121511073unhealed
unheard1136943unheard
unhelmed1435993unhelmed
unhelms1234223unhelms
unhelped1435923unhelped
unhewn12285253unhewn
unholy1238163unholy
unhood1039233unhood
unkend11309223unkend
unlead73312373unlead
unled64021073unle_d
unmold9148313unmold
unpeeled11118533unpeeled
unpiled102312743unpiled
unread73412673unread
unsell63512543unsell
unshed10313773unshe_d
unshell1047113unshell
unsold71410513unsold
untold7149683untold
unwed94114873unwe_d
unwell9349443unwell
upbear1096493upbear
upbeat10911513upbeat
upbind11246303upbind
upbuild1243003upbuild
upends9438763up_ends
upfolds13133753upfolds
upgird10103933upgird
upheaped1633643upheaped
upheaps1494233upheaps
upheave1544023upheave
upheaved1733763upheaved
uphills1295233uphills
uphoard1344573uphoard
upholder1444083upholder
uphove1436133uphove
uphroe1136083uphroe
upkeep1434143upkeep
upland938863upland
upleap10106843upleap
upload9257783upload
upper93714263uppe_r
uppers102912283uppers
uppile10178503uppile
uppiled12216593uppiled
uprear8168793uprear
upsends10265293upsends
upsent83314063upsent
upset73222593upse_t
upsets8409683upsets
upswell1242723upswell
uptalk1234653uptalk
uptear896783uptear
uptilt8410803uptilt
uptrend1044293uptrend
upward12147163upward
upwelled1434663upwelled
upwells12244293upwells
upwind12255823upwind
urged75316033urge_d
urped84615283urpe_d
used55722823u_se_d
usher84517763ushe_r
ushered1139153ushered
ushers94415533ushers
veld85323203__veld
weld84727733__weld
whelk154311063_whelk
whelm134611983_whelm
whelp136012093_whelp
wield95213913_wield
yeld811423873__yeld
yield9519693_yield

Search took 8 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.1401276364.3
2DLD Change Limit1127162306.78016624.8
3Display Results2302300.0802875.0
 (SQL Overall)1786912307.00025527.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.