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

198 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
reined7442552(None) 
peined94918841peined
rained75024601rained
refined114720001refined
reigned949211reigned
reinked1239791reinked
reived104518131reived
relined85321931relined
repined104918771repined
resined84522651resined
ruined74813321ruined
seined74023061seined
veined104413911veined
alined75221402alined
beaned95621472beaned
brained103816102brained
brined95118412brined
ceiled94114952ceiled
chined125620062chined
coined94523602coined
deaned84620452deaned
defined123813822defined
deiced104214482deiced
deigned1037502deigned
denied84318632denied
denned84215632denned
dined76431992_dined
drained93713252drained
dwined114610212dwined
ermined10410602ermined
feigned1245352feigned
feinted11379622feinted
fined94930502_fined
foined105915012foined
gained84617462gained
grained93814272grained
greened93111262greened
groined92710812groined
heiled104415612heiled
heired103813042heired
jeaned143813462jeaned
joined144613072joined
keened114013632keened
kenned114411272kenned
kerned114112932kerned
leaned73422542leaned
lined64934642_lined
mined85333352_mined
neoned7311482neoned
opined95113852opined
pained95622852pained
peened94318162peened
peised94817682peised
penned94217612penned
pined85935322_pined
preened103214992preened
raided85017702raided
railed74727542railed
raised76120332raised
ravined115411822ravined
reamed94326122reamed
reaped94122452reaped
reared75930012reared
reaved104523922reaved
rebind94416932rebin_d
rebred95816352rebred
recaned102817202recaned
recited104319102recited
recked134821802recked
reclined113613602reclined
recoined113614422recoined
redded94019552redded
reded74829122re_ded
redlined103811232redlined
redyed114611242redyed
reed55549622re__ed
reeded84022562reeded
reefed103816582reefed
reeked113717642reeked
reeled74725532reeled
reeved104118712reeved
refed93921922re_fed
refeed104717622refeed
reffed134712512reffed
refiled114318652refiled
refind104717072refin_d
refine95225692refine_
refiner105316912refiner
refines105426342refines
refired115116992refired
refixed183611152refixed
regained102111242regained
rehinged1336852rehinged
rehired115013152rehired
reified112913782reified
rein46040892rein__
reindex1536092reindex
reink95518092rein_k
reinks105012152reinks
reins56234562rein_s
reinter73116842reinter
reive85522942reive_
reiver95318292reiver
reives95723042reives
rejoined16318592rejoined
relend76116452relend
relied74926232relied
reline65434352reline_
relines75331322relines
relinked1337002relinked
relived115114682relived
remained112412892remained
remend95216552remend
remind94819792remin_d
reminded123411522reminded
reminted113615082reminted
remised103516842remised
remixed173510742remixed
rend56136572re_n_d
rended84524102rended
renew83917512re_new
rennet64624852rennet
rented74426592rented
reoiled84316852reoiled
repine85627812repine_
repiner94816902repiner
repines94927382repines
repinned1157472repinned
repled93319782repled
repped114616722repped
reseed74823292reseed
resend75016772resend
reshined123011122reshined
resided95217702resided
resigned1038862resigned
resiled84621982resiled
resited85122422resited
resized174614902resized
rested74430782rested
retained93016092retained
retied75924982retied
retiled84420512retiled
retimed104714652retimed
retine66237332retine_
retines75134672retines
retinted94414362retinted
retinued95210822retinued
retired84620142retired
retted74826312retted
retuned86613972retuned
reused75419562reused
reviled114417922reviled
revised113815482revised
revived144211652revived
revved13469722revved
rewed95425452re_wed
rewind104715882rewin_d
rewinded13277672rewinded
rewired115413282rewired
rexine134719442rexine_
rexines144719152rexines
rezoned173611162rezoned
riced85825542r_iced
riled65833252r_iled
rimed84826372r_imed
rind56535602r_in_d
rinded84418982r_inded
ringed84623842r_inged
rinsed75016352r_insed
riped85226432r_iped
rived94825612r_ived
roiled74320052roiled
rosined84911902rosined
ruiner64013642ruiner
sained75424242sained
seine55732872seine_
seiner64622482seiner
seines65029902seines
seised74218122seised
seized164313652seized
shined104620782shined
skeined1236772skeined
spined95423942spined
teind6213612tein_d
tined65434532_tined
trained84117202trained
trined74920712trined
twined104413122twined
veiled103714542veiled
veiner94514752veiner
vined95626152_vined
weaned103816152weaned
weened104013732weened
weiner94214132weiner
whined134715202whined
wined94434182_wined
yeaned103813902yeaned
yenned10409382yenned

Search took 4 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 Filter178691825510.356501941.0
2DLD Change Limit825511982.56332208.7
3Display Results1981980.0633142.9
 (SQL Overall)1786911982.98259923.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.