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

290 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
riped8522643(None) 
biped104718831biped
griped104114711griped
piped105123161piped
raped85334621raped
riced85825541riced
riled65833251riled
rimed84826371rimed
ripe66038921ripe_
ripen75619261ripen
riper74328401riper
ripes75435771ripes
ripped114419011ripped
rived94825611rived
roped84630801roped
siped84927681siped
wiped114722081wiped
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
aliped95414282aliped
amped104820512amped
aped78538152_aped
ariled75620322ariled
bided95424962bided
biked125320032biked
bipeds11458052bipeds
bipod104410822bipod
bribed115312842bribed
brined95118412brined
caped104931802caped
cited84421952cited
coped105036842coped
craped116120522craped
creped114115702creped
cried84624282cri_ed
crimped143910762crimped
cripe95521142cripe_
cripes105120872cripes
crisped124010102crisped
diced95824682diced
died66137852di_ed
diked115024682diked
dined76431992dined
dipped123517492dipped
dived106321372dived
doped95326712doped
draped105314362draped
dried75321382dri_ed
dripped13408082dripped
duped95118322duped
fifed125115972fifed
filed95331902filed
fined94930502fined
fired94829742fired
fixed165416952fixed
fried95322912fri_ed
frized193510682frized
gaped96123532gaped
gibed96215962gibed
gied64631982gi_ed
gimped123911472gimped
gipped124815902gipped
grided95117042grided
grimed104714092grimed
gripe84622962gripe_
griper94114612griper
gripes94619872gripes
gripey124111202gripey
gripped13419342gripped
groped107515052groped
hided105222442hided
hied85434042hi_ed
hiked135919202hiked
hipped144317692hipped
hired95226262hired
hived125217912hived
hoped115628182hoped
hyped145313332hyped
iced78721892_iced
imped105117982imped
ired55131872_ired
irised73913152irised
irked104510922irked
japed156217632japed
jibed155114162jibed
jived165115042jived
kipped153114572kipped
kited105120092kited
lied55838092li_ed
liked104523812liked
limed85426802limed
limped114817122limped
lined64934642lined
lipe66839732lipe_
lipid85916172lipid
lipped114419542lipped
lisped94113422lisped
lived95523722lived
loped85128332loped
miked125020452miked
mimed105622732mimed
mined85333352mined
mired85729222mired
mixed155717252mixed
moped105424732moped
nided75920872nided
nipped113615852nipped
nixed135714222nixed
oiled64429472oiled
oped76230152_oped
ped66751522__ped
pied75035362pi_ed
piked125623312piked
piled85232992piled
pimped134913482pimped
pined85935322pined
pipe86434432pipe_
piper96523192piper
pipes96030142pipes
pipet95533322pipet
pipped104516542pipped
priced115018882priced
prided103618032prided
pried84426862pri_ed
primed115118912primed
primped14479152primped
prised94322202prised
prized184415392prized
raced87635312raced
raged74829452raged
raided85017702raided
railed74727542railed
rained75024602rained
raised76120332raised
raked105831422raked
ramped114617902ramped
rape65041632rape_
raper74932752raper
rapes75740722rapes
rapid86422032rapid
rapped114122682rapped
rared65738322rared
rased65033932rased
rasped94715202rasped
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
reaped94122452reaped
red46755802r__ed
reded74829112reded
reed55549622r_eed
refed93921922refed
reined74425522reined
reived104518132reived
repeg84015052repeg
repel74921402repel
repled93319782repled
repped114616722repped
rewed95425452rewed
ribbed114014372ribbed
ribes75530172ribes
rice64942912rice_
ricer74726612ricer
rices75536152rices
ricked136523622ricked
rid46754622ri__d
ridded93615122ridded
ride55945122ride_
rider65231302rider
rides66140812rides
ridged94014212ridged
riel46432382ri_el
rife74632322rife_
rifer84721982rifer
riffed133811562riffed
rifled104115002rifled
rifted104115312rifted
rigged94517402rigged
rigid7913892rigid
rile45650532rile_
riles55343642riles
riley84420582riley
rilled74525652rilled
rime65138882rime_
rimer75429242rimer
rimes75634542rimes
rimmed114812302rimmed
rimpled123311422rimpled
rind56535602ri_nd
rinded84418982rinded
ringed84623842ringed
rinsed75016352rinsed
rioted73416372rioted
rip56851302rip__
ripely112511152ripely
ripened1038202ripened
ripens85012172ripens
ripest84317942ripest
ripper103518652ripper
rippled123110272rippled
rips66237432rip_s
rise45945232rise_
risen54621882risen
riser55431052riser
rises55244042rises
risked115514632risked
rite45849452rite_
rites54442552rites
rive75537722rive_
riven85121622riven
river85731692river
rives85336002rives
rivet85636362rivet
robed85323732robed
roiled74320052roiled
romped114513652romped
rope65542912rope_
roper75431912roper
ropes75940062ropes
ropey106021872ropey
rosed65930342rosed
rouped95717352rouped
roved95323552roved
rowed94034322rowed
rued55729792r_ued
ruined74813322ruined
ruled65822522ruled
rupee7321282rupee
ryked13669512ryked
sided74825952sided
sipe67341042sipe_
sipes76036952sipes
sipped113720632sipped
sired66134282sired
sited65130742sited
sized155519242sized
sliped95417062sliped
sniped94913482sniped
sped76031492_sped
spied85427712spied
stiped94517072stiped
striped105214362striped
swiped123811092swiped
taped85327422taped
tided76322512tided
tied55535212ti_ed
tiled64832942tiled
timed85223612timed
tined65434532tined
tipped114418262tipped
tired65228902tired
toped85631312toped
triced95518672triced
tried65026912tri_ed
trined74920712trined
tripe75425382tripe_
tripes85324872tripes
tripled104113832tripled
tripod9399852tripod
tripped123911692tripped
typed115815452typed
umped104717272umped
upped103715162upped
urped84615282urped
viced115118182viced
vied86328632vi_ed
vined95626152vined
viper105017302viper
vised95518762vised
wifed125117742wifed
wiled95231552wiled
wimped144211512wimped
wined94434182wined
wipe94830282wipe_
wiper105421292wiper
wipes104827082wipes
wired95327642wired
wised95123342wised
wisped123411892wisped
wited94727142wited
wived125121502wived
wried95518562wri_ed
yipe96722182yipe_
yipes106017842yipes
yipped143613282yipped
zipped203612982zipped

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 Limit538002901.48336277.8
3Display Results2902900.0803625.0
 (SQL Overall)1786912901.85996122.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.