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

211 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
shied9612549(None) 
hied85434041_hied
shed86536151sh_ed
shiel811023771shiel
shield106212971shield
shier85428941shier
shies86136551shies
shined104620781shined
shoed95723011shoed
shred98125611shred
skied104417751skied
spied85427711spied
stied65723031stied
ahed89536252ah_ed
ashed97829772ash_ed
ashier94714832ashier
chid106626402chi_d
chide115321012chide
chided135113962chided
chief134419482chief
chiel104918972chiel
chield124610212chield
child114516222child
chimed145814832chimed
chined125620062chined
cried84624282cried
died66137852_died
dried75321382dried
espied9359772espied
flied96519432flied
fried95322912fried
gied64631982_gied
haed86338582_haed
heed86437602_heed
hid76248382_hi_d
hide85134642_hide
hided105222442_hided
hie67652702_hie_
hies74842832_hies
hiked135919202_hiked
hind85529752_hind
hired95226262_hired
hived125217912_hived
hoed87837982_hoed
hued86925852_hued
ivied94710522ivied
lied55838092_lied
ohed87825182oh_ed
pied75035362_pied
plied85118592plied
pried84426862pried
sabed86526812sabed
said55742112sai_d
sailed74327762sailed
sained75424242sained
saned65636272saned
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
scried95817302scried
seed55549482s_eed
seined74023062seined
seised74218122seised
seized164313652seized
sered65737292sered
sewed95325162sewed
sexed136618542sexed
shad86230912sh_ad
shade95125582shade
shaded114518872shaded
shaird10288702shaird
shaled105023952shaled
shamed125120212shamed
shaped125020102shaped
shard96125962shard
shared105829062shared
shaved135118382shaved
shawed134817232shawed
she66837692sh_e_
shea76031572sh_ea
sheds96122702sh_eds
sheen85023312sheen
sheep105321522sheep
sheer84726892sheer
sheet84836962sheet
sheik122514662sheik
shend94719972shend
sherd96321152sherd
shes75734352sh_es
shew108030762sh_ew
shewed134716182shewed
shields11538042shields
shiels95418922shiels
shiers94921752shiers
shiest95821532shiest
shift114225142shift
shifted14359982shifted
shill85325332shill
shilled113313622shilled
shily115222012shily
shim95827862shi_m
shimmed15338582shimmed
shims104422552shims
shin75634312shi_n
shindy13449322shindy
shine85533092shine
shiner93820872shiner
shines95028912shines
shinned114310912shinned
shins85131042shins
shiny115122142shiny
ship95228242shi_p
shipped153312102shipped
ships105123772ships
shire84727132shire
shires95225572shires
shirk124817842shirk
shirked153710462shirked
shirr84716922shirr
shirred113710502shirred
shirt84533902shirt
shist84829612shist
shit76745942shi_t
shits84731172shits
shitted114212052shitted
shiv105721172shi_v
shiva115915002shiva
shive114423422shive
shiver124517372shiver
shives124921412shives
shivs115018802shivs
shlep104914832shlep
shod86225062sh_od
shoe75933442shoe_
shoer84722162shoer
shoes85429662shoes
shooed103916082shooed
shored105723652shored
shoved134214282shoved
showed135016972showed
shreds105613052shreds
shrew119720172shrew
shrewd136810782shrewd
shriek134211102shriek
shrined114112412shrined
shrived144712182shrived
shuted103913172shuted
shyer114714782shyer
side55444492s_ide
sided74825952sided
sild55030582s_ild
siped84927682siped
sired66134282sired
sited65130742sited
sized155519242sized
skeed105018982skeed
skid95720932ski_d
skier95119592skier
skies95026832skies
skiey125012892skiey
skited114313482skited
skived14429892skived
skyed13529922skyed
sled55334372s_led
sliced94416312sliced
slid55828982sli_d
slide64725412slide
slier54827242slier
slimed94915122slimed
sliped95417062sliped
slued64220512slued
smiled93716432smiled
sned56026052s_ned
snide64318722snide
sniped94913482sniped
soiled73822472soiled
soled65835172soled
sored66141782sored
sowed94933862sowed
spaed85522272spaed
sped76031492s_ped
speed85526622speed
spiced115218312spiced
spiel74623912spiel
spier75728032spier
spies76037622spies
spiked134915552spiked
spiled94621992spiled
spined95423942spined
spired94921862spired
spited94820442spited
spued84918472spued
steed66024942steed
sties55132982sties
stiped94517072stiped
styed95815482styed
sued56537932s_ued
suited74019422suited
swiped123811092swiped
swived133610632swived
thief114516302thief
third95912492third
tied55535212_tied
tried65026912tried
vied86328632_vied
whid115418872whi_d
whiled134514132whiled
whined134715202whined
whited134814082whited
wried95518562wried

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 Filter178691538000.310576422.6
2DLD Change Limit538002111.42337807.4
3Display Results2112110.0633349.2
 (SQL Overall)1786912111.79699493.9
 
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.