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

270 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
rived9482561(None) 
dived106321371dived
hived125217911hived
jived165115041jived
lived95523721lived
raved94931431raved
reived104518131reived
riced85825541riced
riled65833251riled
rimed84826371rimed
riped85226431riped
rive75537721rive_
riven85121621riven
river85731691river
rives85336001rives
rivet85636361rivet
roved95323551roved
wived125121501wived
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
aiver85725162aiver
ariled75620322ariled
arrived11127352arrived
bided95424962bided
biked125320032biked
biped104718832biped
braved124817442braved
bribed115312842bribed
brined95118412brined
caved116227562caved
cited84421952cited
civet105828732civet
coved115027372coved
craved125417772craved
cried84624282cri_ed
derived123912762derived
diced95824682diced
died66137852di_ed
diked115024682diked
dined76431992dined
dive85634772dive_
diver94827802diver
dives95832402dives
dried75321382dri_ed
drive95318002drive_
drivel105110382drivel
driven105210142driven
driver104714492driver
drives105117112drives
droved114611642droved
eaved95924502eaved
fifed125115972fifed
filed95331902filed
fined94930502fined
fired94829742fired
five107629742five_
fiver116024942fiver
fives116027362fives
fixed165416952fixed
fried95322912fri_ed
frized193510682frized
gibed96215962gibed
gied64631982gi_ed
give85829352give_
given95915282given
giver94921202giver
gives95324872gives
graved114818812graved
grided95117042grided
grieved1235282grieved
grimed104714092grimed
griped104114712griped
grivet103517822grivet
groved114413702groved
gyved13568742gyved
hided105222442hided
hied85434042hi_ed
hiked135919202hiked
hired95226262hired
hive106029672hive_
hives116925512hives
iced78721892_iced
ired55131872_ired
irised73913152irised
irked104510922irked
ivied94710522_ivied
jibed155114162jibed
jive146123592jive_
jiver155119052jiver
jives154820812jives
jivey185111872jivey
kited105120092kited
laved95028592laved
lied55838092li_ed
liked104523812liked
limed85426802limed
lined64934642lined
live76540992live_
liven85021732liven
liver85132962liver
lives86133192lives
livid96714422livid
loved95021362loved
miked125020452miked
mimed105622732mimed
mined85333352mined
mired85729222mired
mixed155717252mixed
moved114218152moved
nided75920872nided
nixed135714222nixed
oiled64429472oiled
paved115525262paved
pied75035362pi_ed
piked125623312piked
piled85232992piled
pined85935322pined
piped105123162piped
priced115018882priced
prided103618032prided
pried84426862pri_ed
primed115118912primed
prised94322202prised
privet113821342privet
prized184415392prized
proved125016032proved
raced87635312raced
raged74829452raged
raided85017702raided
railed74727542railed
rained75024602rained
raised76120332raised
raked105831422raked
raped85334622raped
rared65738322rared
rased65033932rased
rated65441382rated
rave75542092rave_
ravel84621512ravel
raven84723442raven
raver85631492raver
raves85441972raves
raxed135622662raxed
rayed95127502rayed
razed155027982razed
reaved104523922reaved
red46755802r__ed
reded74829112reded
reed55549622r_eed
reeved104118712reeved
refed93921922refed
reined74425522reined
reive85522942reive_
reiver95318292reiver
reives95723042reives
relived115114682relived
revel84423162revel
revet84938842revet
revived144211652revived
revved13469722revved
rewed95425452rewed
ribbed114014372ribbed
ribes75530172ribes
rice64942912rice_
ricer74726612ricer
rices75536152rices
ricked136523622ricked
rid46754622ri__d
ridded93615122ridded
ride55945122ride_
rider65231302rider
rides66140812rides
ridged94014212ridged
riel46432382ri_el
riever94811652riever
rife74632322rife_
rifer84721982rifer
riffed133811562riffed
rifled104115002rifled
rifted104115312rifted
rigged94517402rigged
rigid7913892rigid
rile45650532rile_
riles55343642riles
riley84420582riley
rilled74525652rilled
rime65138882rime_
rimer75429242rimer
rimes75634542rimes
rimmed114812302rimmed
rind56535602ri_nd
rinded84418982rinded
ringed84623842ringed
rinsed75016352rinsed
rioted73416372rioted
ripe66038922ripe_
ripen75619262ripen
riper74328402riper
ripes75435772ripes
ripped114419012ripped
rise45945232rise_
risen54621882risen
riser55431052riser
rises55244042rises
risked115514632risked
rite45849452rite_
rites54442552rites
rival85216502rival
rivaled1138932rivaled
rivers94626542rivers
riveted11258572riveted
rivets94417112rivets
robed85323732robed
roiled74320052roiled
roped84630802roped
rosed65930342rosed
rove75136982rove_
roven85521972roven
rover85527372rover
roves84834482roves
rowed94034322rowed
rued55729792r_ued
ruined74813322ruined
ruled65822522ruled
ryked13669512ryked
saved95127112saved
scrived134511112scrived
shrived144712182shrived
sided74825952sided
sieved104611442sieved
siped84927682siped
sired66134282sired
sited65130742sited
siver85728612siver
sized155519242sized
skived14429892skived
strived114713662strived
swived133610632swived
thrived14458182thrived
tided76322512tided
tied55535212ti_ed
tiled64832942tiled
timed85223612timed
tined65434532tined
tired65228902tired
triced95518672triced
tried65026912tri_ed
trined74920712trined
trivet93721882trivet
viced115118182viced
vied86328632vi_ed
vined95626152vined
vised95518762vised
vive105426622vive_
vivid125112312vivid
waived134511282waived
waved125223582waved
wifed125117742wifed
wiled95231552wiled
wined94434182wined
wiped114722082wiped
wired95327642wired
wised95123342wised
wited94727142wited
wive105931752wive_
wiver115924512wiver
wives115328922wives
wried95518562wri_ed

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.0931921408.6
2DLD Change Limit538002701.62333148.5
3Display Results2702700.0803375.0
 (SQL Overall)1786912701.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.