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

356 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
riled6583325(None) 
ailed66240281ailed
ariled75620321ariled
filed95331901filed
oiled64429471oiled
piled85232991piled
railed74727541railed
riced85825541riced
rifled104115001rifled
rile45650531rile_
riles55343641riles
riley84420581riley
rilled74525651rilled
rimed84826371rimed
riped85226431riped
rived94825611rived
roiled74320051roiled
ruled65822521ruled
tiled64832941tiled
wiled95231551wiled
abled86926832abled
aided75828932aided
aimed85626052aimed
aired66032922aired
aisled74516182aisled
argled85314552argled
axled135315812axled
bailed94726652bailed
baled85436442baled
bided95424962bided
bield84614652bield
biked125320032biked
bile66147182bile_
biles75542142biles
bilged105513182bilged
bilked134012942bilked
billed94224902billed
biped104718832biped
birled94416992birled
bled75729312_bled
boiled95020952boiled
brailed103914012brailed
bribed115312842bribed
bridled113611142bridled
brined95118412brined
broiled103811422broiled
ceiled94114952ceiled
cited84421952cited
coiled95123942coiled
coled85540762coled
cried84624282cri_ed
deled75326542deled
dialed84716452dialed
diced95824682diced
died66137852di_ed
diked115024682diked
dilled84122222dilled
dined76431992dined
dirled84514902dirled
dived106321372dived
doiled84817292doiled
doled75430912doled
dried75321382dri_ed
drilled94711672drilled
exiled144712462exiled
failed105421602failed
field95015322field
fifed125115972fifed
file75446642file_
filer85433002filer
files85441272files
filet85540162filet
filled104922262filled
filmed124610362filmed
fined94930502fined
fired94829742fired
fixed165416952fixed
fled85429772_fled
flied96519432flied
foiled104618402foiled
fried95322912fri_ed
frilled113911602frilled
frized193510682frized
gibed96215962gibed
gied64631982gi_ed
gild65526512gil_d
gilded94413222gilded
gilled84521632gilled
gled65631142_gled
grided95117042grided
grilled94012832grilled
grimed104714092grimed
griped104114712griped
guiled84315382guiled
hailed104122742hailed
haled95335822haled
heiled104415612heiled
hided105222442hided
hied85434042hi_ed
hiked135919202hiked
hilled104022222hilled
hilted104016042hilted
hired95226262hired
hived125217912hived
holed95634132holed
iced78721892_iced
idled74915212idled
ilea45931462_ilea
ilex115822032_ilex
ired55131872_ired
irised73913152irised
irked104510922irked
isled64615992isled
jailed144917422jailed
jibed155114162jibed
jilted144111352jilted
jived165115042jived
killed113918772killed
kilned11368392kilned
kilted113613832kilted
kited105120092kited
led46254552__led
lied55838092li_ed
liked104523812liked
lilied73913212lilied
lilted73715372lilted
limed85426802limed
lined64934642lined
lived95523722lived
mailed95326752mailed
miked125020452miked
mild75330852mil_d
milded104416152milded
mile66352572mile_
miler75733062miler
miles74645072miles
milked134612572milked
milled94326172milled
milted93919942milted
mimed105622732mimed
mined85333352mined
mired85729222mired
misled94719312misled
mixed155717252mixed
moiled94318862moiled
muled85824432muled
nailed74021492nailed
naled65525052naled
nided75920872nided
nilled73919452nilled
nixed135714222nixed
ogled75915962ogled
oiler54628282oiler
paled85538722paled
periled10316322periled
pied75035362pi_ed
piked125623312piked
pile65649692pile_
pilea75123952pilea
pilei74021782pilei
piles74742612piles
pilled94222752pilled
pined85935322pined
piped105123162piped
pled75231432_pled
plied85118592plied
poled84934842poled
priced115018882priced
prided103618032prided
pried84426862pri_ed
prilled104713002prilled
primed115118912primed
prised94322202prised
prized184415392prized
puled84926522puled
raced87635312raced
raged74829452raged
raided85017702raided
railer64524932railer
rained75024602rained
raised76120332raised
raked105831422raked
rale45050562rale_
rales54947492rales
raped85334622raped
rared65738322rared
rased65033932rased
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
red46755802r__ed
reded74829122reded
reed55549622r_eed
reeled74725532reeled
refed93921922refed
refiled114318652refiled
reined74425522reined
reived104518132reived
relend76116452relend
relet54749822relet
relied74926232relied
reoiled84316852reoiled
repled93319782repled
resiled84621982resiled
retiled84420512retiled
reviled114417922reviled
rewed95425452rewed
ribbed114014372ribbed
ribes75530172ribes
riblet84222442riblet
rice64942912rice_
ricer74726612ricer
rices75536152rices
ricked136523622ricked
rid46754632ri__d
ridded93615122ridded
riddled103012042riddled
ride55945132ride_
rider65231302rider
rides66140812rides
ridged94014222ridged
ridley10169542ridley
riel46432382ri_el
riels55121332riels
rife74632322rife_
rifer84721982rifer
riffed133811562riffed
riffled14338602riffled
rifle85518332rifle_
rifler94014262rifler
rifles94217702rifles
rifted104115312rifted
rigged94517402rigged
rigid7913892rigid
rill45140902ril_l
rille55728732rille
rilles64725502rilles
rillet64828852rillet
rills55032712rills
rime65138882rime_
rimer75429242rimer
rimes75634542rimes
rimmed114812302rimmed
rimpled123311422rimpled
rind56535602ri_nd
rinded84418982rinded
ringed84623842ringed
rinsed75016352rinsed
rioted73416372rioted
ripe66038922ripe_
ripen75619262ripen
riper74328402riper
ripes75435772ripes
ripped114419012ripped
rippled123110272rippled
rise45945232rise_
risen54621882risen
riser55431052riser
rises55244042rises
risked115514632risked
rite45849452rite_
rites54442552rites
rivaled1138932rivaled
rive75537722rive_
riven85121622riven
river85731692river
rives85336002rives
rivet85636362rivet
robed85323732robed
role45851822role_
roles56747982roles
rolfed104510522rolfed
rolled74220242rolled
roped84630802roped
rosed65930342rosed
roved95323552roved
rowed94034322rowed
rued55729792r_ued
ruined74813322ruined
rule49938422rule_
ruler54923342ruler
rules55234252rules
ryked13669512ryked
sailed74327762sailed
sided74825952sided
sidled84215172sidled
sild55030582sil_d
silex123417412silex
silked114314812silked
siloed74615302siloed
silted74020012silted
siped84927682siped
sired66134282sired
sited65130742sited
sized155519242sized
sled55334372_sled
smiled93716432smiled
soiled73822472soiled
soled65835172soled
spiled94621992spiled
tailed74424662tailed
tided76322512tided
tied55535212ti_ed
tilde65017342tilde
tile45451442tile_
tiler56131022tiler
tiles55542102tiles
tilled74722952tilled
tilted74616862tilted
timed85223612timed
tined65434532tined
tired65228902tired
tirled74714362tirled
titled73815002titled
toiled74420322toiled
toled65934922toled
trailed83415672trailed
triced95518672triced
tried65026912tri_ed
trifled113711962trifled
trilled84116312trilled
trined74920712trined
tripled104113832tripled
unled64021072unled
vailed104619292vailed
veiled103714542veiled
vialed105112592vialed
viced115118182viced
vied86328632vi_ed
vile76139802vile_
viler86324162viler
vined95626152vined
vised95518762vised
voled95323722voled
wailed104823592wailed
waled94330992waled
whiled134514132whiled
wield95213912wield
wifed125117742wifed
wild85126512wil_d
wilded113714502wilded
wile75944372wile_
wiles85437872wiles
willed104722452willed
wilted103915712wilted
wined94434182wined
wiped114722082wiped
wired95327642wired
wised95123342wised
wited94727142wited
wived125121502wived
wried95518562wri_ed
wyled124611842wyled
yield9519692yield

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.296603685.8
2DLD Change Limit538003561.47036598.6
3Display Results3563560.1103236.4
 (SQL Overall)1786913561.87695251.1
 
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.