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

235 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
weld8472773(None) 
eld46733801_eld
geld65828431geld
held85330401held
meld75830471meld
veld85323201veld
weald95615021weald
wed75843631we_d
weed85637511weed
welds94719161welds
well75832041well
welt75547861welt
wend85330451wend
wield95213911wield
wild85126521wild
wold85429071wold
yeld811423871yeld
auld54125362auld
awed88436032awe_d
bald76432902bald
bead75937922bead
bed67950632be_d
bel57148462bel_
bell66237182bell
bels66142492bels
belt65754032belt
bend76435262bend
bield84614652bield
bled75729312bled
bold75432812bold
cel56040552cel_
cell65031722cell
cels65534972cels
celt65646712celt
cold77338772cold
dead65434242dead
deed65340902deed
del46752752del_
dele56843082dele
deled75326542deled
delf85436572delf
deli55631292deli
dell56938202dell
dels56745472dels
delt57855272delt
dwell9519852dwell
dwelt94316522dwelt
ed38645192_e_d
eel37946842eel_
eels46536742eels
eely77725212eely
el26745292_el_
elds56324862_elds
elf66138522_elf
elk76726122_elk
ell36735682_ell
elm57531742_elm
els37645722_els
end46834362_end
fed76548362fe_d
feed84538902feed
felid94717172felid
fell76833072fell
felt75146932felt
fend84832972fend
feod815523002feod
feud86523022feud
field95015322field
fjeld16465582fjeld
fled85429772fled
fold86528942fold
ged57044542ge_d
geed65435502geed
gel45642432gel_
gelds75118342gelds
gelid74916982gelid
gels56836102gels
gelt56448012gelt
gild65526522gild
gled65631142gled
gold65430162gold
head87137172head
heed86437602heed
hell75637892hell
helm95530022helm
helo75332852helo
help95328922help
herd84933062herd
hold86235062hold
jeed125428502jeed
jell117125872jell
kelp105322812kelp
kelt85343202kelt
lead56038852lead
led46254562le_d
lend56233672lend
leud57223422leud
lewd85716592lewd
mead75531602mead
med66146752me_d
meed74934702meed
mel56047482mel_
melds84822382melds
mell64935612mell
mels65941532mels
melt65752892melt
mend75334032mend
mild75330862mild
mold76034332mold
need54934152need
nerd56624942nerd
old47033472_old
owed86833872owe_d
ped66751532pe_d
peed76239182peed
pele65539552pele
pelf97031452pelf
pelt67651082pelt
pend75934532pend
pled75231432pled
read55942532read
red46755812re_d
redd66323182redd
reed55549622reed
rely75428952rely
rend56136572rend
reweld103711112reweld
seed55549482seed
sel38253322sel_
self75138292self
sell45840612sell
sels46345982sels
send55237292send
sild55030592sild
sled55334372sled
sold54837412sold
swell84815982swell
ted46446572te_d
teed55439262teed
tel35647902tel_
tela45532972tela
tele45040872tele
tell44934702tell
tels46841692tels
tend56433772tend
told56132202told
tweed94915092tweed
vela75725542vela
velds95615582velds
veldt94819862veldt
vend86626422vend
wad77053902w_ad
wale74546442wale
waled94331002waled
walk115625612walk
wall76236102wall
waly105830902waly
wand85833882wand
ward86542252ward
we57043452we__
weak117126302weak
weal75838682weal
wealds10459102wealds
weals85428742weals
wean75734352wean
wear75836722wear
web85735562we_b
webs96622122webs
weds86628942weds
wee66760812we_e
weeds95222212weeds
weedy125115002weedy
week116428152week
weel75834082weel
ween75835462ween
weep95131652weep
weer75535092weer
wees76249122wees
weet75254152weet
weft105435012weft
weir76019922weir
weird95111282weird
weka117013872weka
welch134411492welch
welded114013382welded
welder102914412welder
weldor10317652weldor
welled103820212welled
wells85426192wells
welly114620012welly
welsh113110362welsh
welted103715822welted
welts85225192welts
wen66249602we_n
wends95822812wends
wens76337932wens
went76051872went
wept95635052wept
were76238332were
wert79749822wert
west75748082west
wet65966622we_t
wetly114511712wetly
wets75940292wets
whelk154311062whelk
whelm134611982whelm
whelp136012092whelp
whid115418882whid
wields10469622wields
wieldy13476182wieldy
wilds94818212wilds
wile75944382wile
wiled95231552wiled
will75737522will
wilt76246302wilt
wily106428822wily
wind85533862wind
woad85523942woad
woald94813072woald
wolds95420182wolds
wolf105729562wolf
wood85329382wood
word89832002word
world96915362world
would95513152would
wud76227162w_ud
wyle105519382wyle
wyled124611842wyled
wynd116114462wynd
yald86920612yald
yelk115320002yelk
yell76028322yell
yelp95621352yelp
yield9519692yield
zed135431182ze_d

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.280638182.1
2DLD Change Limit298722350.84335435.3
3Display Results2352350.0504700.0
 (SQL Overall)1786912351.173152336.7
 
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.