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 “ripened” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

349 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
ripened103820(None) 
ripener937901ripener
crispened1443612crispened
dizened18267332dizened
likened12267352likened
lippened13255222lippened
livened11238932livened
opened94311862_opened
ravened115012282ravened
reopened1138502reopened
repented112614982repented
repined104918772repined
richened1435952richened
riped85226432rip__ed
ripen75619262ripen__
ripeners1036832ripeners
ripeness1039362ripeness
ripens85012172ripen_s
ripped114419012rip_ped
rippled123110272rippled
riveted11258572riveted
unripened1244392unripened
widened12328052widened
wizened20275422wizened
aliened81011743aliened
append1138273appen_d
appended1435483appended
binned94414543bi_nned
biped104718833bip__ed
brazened20134903brazened
briefed1335743bri_efed
brined95118413bri__ned
capered123014043capered
ciphered1637053ciphered
cozened19349183cozened
cravened1476713cravened
crippled15336793crippled
cupeled1257793cupeled
dampened1435623dampened
davened124610073davened
deepened1235653deepened
depend103510923depen_d
depended1337983depended
deponed113712873deponed
diapered1238003diapered
diene65720133di_ene_
dienes75719903di_enes
dieted83115493di_eted
dined76431993di__ned
dinned84317613di_nned
dipnet91317473dip_net
dipped123517493dip_ped
dispend11289413dispen_d
dispended14147823dispended
dispensed13158773dispensed
divined12329693divined
dovened12389063dovened
dozened18377453dozened
dripped13408083drip_ped
driveled1374973driveled
evened101010313_evened
expend16247503expen_d
expended19136543expended
expensed18126413expensed
fibered1337643fibered
fiend95312983fi_en_d
fileted1159093fileted
fined94930503fi__ned
finned104114603fi_nned
friend10388933fri_en_d
friended1335033fri_ended
ginned83813983gi_nned
gipped124815903gip_ped
gipsied1135873gipsied
girned84010513gi_rned
greened93111263greened
grieved1235283gri_eved
grinned9378553gri_nned
griped104114713grip__ed
gripped13419343grip_ped
happened1635653happened
havened14429243havened
hipped144317693hip_ped
hoidened1335653hoidened
hyphened2044683hyphened
impeded13418183impeded
impend11478793impen_d
impended1435953impended
imponed12279453imponed
inned64118423_i_nned
ironed74916013_ironed
itemed936603_itemed
keened114013623_keened
kilned11368393ki_lned
kipped153114573kip_ped
kippered17255623kippered
kirned11408623ki_rned
kittened1334523kittened
ladened979053ladened
lapeled10258893lapeled
latened8711923latened
libeled10249413libeled
licenced13145773licenced
licensed11145723licensed
lichened1435753lichened
limned94811473li_mned
lined64934643li__ned
lipped114419543lip_ped
lippered13287953lippered
listened9168813listened
livener10278943livener
livered113111633livered
mildened1235773mildened
mimeoed1235193mimeoed
mined85333353mi__ned
mispenned1445413mispenned
mitered103213233mitered
mittened1136363mittened
nipped113615853nip_ped
nippled12307643nippled
omened93711003_omened
opener83910993_opener
opined95113853_opined
oriented937483ori_ented
paned85437183__paned
papered122513163papered
peed76239183__pe_ed
peened94318153_peened
peined94918843__peined
pend75934533__pen_d
pended103819013__pended
penes75839223__penes
penned94217613__penned
pieced113912103pi_eced
pined85935323__pined
pinene82915643pinene_
pinenes93416673pinenes
pinkened1535753pinkened
pinned94818383pi_nned
piped105123163pip__ed
pipelined14164853pipelined
pipetted1335263pipetted
pipped104516543pip_ped
popeyed1535703popeyed
preened103214983preened
prisoned1138813prisoned
propend123311273propen_d
propended1546163propended
propene112716043propene_
propenes122816513propenes
propined133111503propined
proponed132412033proponed
queened17105863queened
racemed1237013racemed
rained75024603r_ained
raped85334623rap__ed
rapeseed1144463rapeseed
rapiered1136053rapiered
rapine85023083rapine_
rapines95120863rapines
rapped114122683rap_ped
rappeled1335003rappeled
rattened9218623rattened
raveled114113633raveled
ravener104110733ravener
ravined115411823ravined
razeed163710013raze_ed
recaned102817203recaned
receded112713043receded
reddened1136423reddened
reded74829113r__eded
redenied10511283redenied
reed55549623r__e_ed
reeded84022563r_eeded
reefed103816583r_eefed
reeked113717643r_eeked
reeled74725533r_eeled
reeved104118713r_eeved
refed93921923r__efed
refeed104717623refe_ed
refenced1438993refenced
refined114720003refined
reigned949213reigned
reined74425523r_eined
rekeyed1536163rekeyed
relend76116453relen_d
relented92614943relented
relined85321933relined
remend95216553remen_d
remended123010393remended
rend56136573r__en_d
rended84524103r__ended
reneged92010763reneged
renew83917513r__enew
renewed11309993renewed
rented74426593r__ented
repand95316063repan_d
repanel939963repanel
repaved133311133repaved
repealed113211873repealed
repeated113117443repeated
repegged1334893repegged
repelled113111573repelled
repent84728873repen_t
repenter102813863repenter
repents93717623repents
reperked15177793reperked
repetend1136223repetend
repine85627813repine_
repiner94816903repiner
repines94927383repines
repinned1157473repinned
repled93319773rep_led
replied103914443replied
reposed103616273reposed
repped114616723rep_ped
repugned1235363repugned
reputed104613483reputed
rerented92516163rerented
reseed74823293rese_ed
resend75016773resen_d
resented92716963resented
resewed113011823resewed
resined84522653resined
retene69224273retene_
retenes76324623retenes
retuned86613973retuned
reveled113917753reveled
revenged1337553revenged
revenued1237223revenued
revered112819333revered
rewed95425453r__ewed
rewidened1444073rewidened
rezoned173611163rezoned
riband9239623riban_d
ribbed114014373ri_bbed
ribboned1343973ribboned
riced85825543ri__ced
ricked136523623ri_cked
ridded93615123ri_dded
riddled103012043riddled
rident7520193riden_t
ridged94014213ri_dged
riever94811653ri_ever
rifeness1138583rifeness
riffed133811563ri_ffed
riffled14338603riffled
rifled104115003ri_fled
rifted104115313ri_fted
rigged94517403ri_gged
righted122912143righted
riled65833253ri__led
rilled74525653ri_lled
rimed84826373ri__med
rimmed114812303ri_mmed
rimpled123311423rimpled
rind56535603ri__n_d
rinded84418983ri_nded
ringed84623843ri_nged
rinsed75016353ri_nsed
rioted73416373ri_oted
ripcord1264463ripcord
ripe66038923rip__e_
ripely112511153ripe_ly
ripening1138573ripening
riper74328403rip__er
ripes75435773rip__es
ripest84317943ripe_st
ripieni944113ripien_i
ripieno944133ripien_o
ripienos1043483ripienos
riping93821613ripin_g
riposted11216933riposted
ripper103518653rip_per
ripple103413913ripple_
rippler113210103rippler
ripples113513293ripples
ripplet113412583ripplet
ripsawed1442533ripsawed
riptide1036883riptide
risen54621883risen__
risked115514633ri_sked
rivaled1138933rivaled
rived94825613ri__ved
riven85121623riven__
riverbed14245143riverbed
riveter10208753riveter
rivetted12226093rivetted
rodeoed937883rodeoed
rogered939553rogered
roped84630803rop__ed
rosined84911903rosined
roweled11269863roweled
ruined74813323r_uined
rupee7321283rupe_e_
rupees8312573rupe_es
sheened113511703sheened
sickened1546783sickened
sieged85212713si_eged
sieved104611443si_eved
signed83413753si_gned
silenced1136273silenced
simpered1338253simpered
sinewed1137053sinewed
sinned73818413si_nned
siped84927683sip__ed
siphoned1446413siphoned
sipped113720633sip_ped
speaned103411523_speaned
speed85526623_spe_ed
spend85619333_spen_d
spewed125512333_spewed
spieled104811883spieled
spiered104412463spiered
spined95423943_spined
stipend10386553stipen_d
supered10316123supered
tapered102612933tapered
tiered73613973ti_ered
tined65434533ti__ned
tinned74317533ti_nned
tipped114418263tip_ped
tippled12358393tippled
tiptoed1036143tiptoed
tokened1236393tokened
trapesed1136473trapesed
triene64316383tri_ene_
trienes74118413tri_enes
trined74920713tri__ned
tripled104113833trip_led
tripped123911693trip_ped
unopened1137023unopened
unpenned1137543unpenned
upend85011043_upen_d
upended11267323_upended
viewed1345993vi_ewed
vined95626153vi__ned
viseed105310983vise_ed
wakened1546873wakened
weened104013733_weened
whitened1535173whitened
widener11318693widener
wiener94513543wi_ener
wined94434183wi__ned
winned104017013wi_nned
wiped114722083wip__ed
yipped143613283yip_ped
zipped203612983zip_ped
zippered22244823zippered

Search took 8 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340273497.34318252.3
3Display Results3493490.1262769.8
 (SQL Overall)1786913497.60923484.2
 
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.