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

171 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
brined9511841(None) 
brained103816101brained
bribed115312841bribed
brinded115112051brinded
brine75132271brine_
briner84519041briner
brines85028851brines
trined74920711trined
alined75221402alined
ariled75620322ariled
bailed94726652bailed
baited95319242baited
baned85436352b_aned
banned94721342banned
barned95623582barned
basined10310002basined
beaned95621472beaned
berimed124912282berimed
beringed1298172beringed
bided95424962b_ided
biked125320032b_iked
bind76234512b_in_d
bine66650862b_ine_
biner75930692b_iner
bines76946792b_ines
binged105920822b_inged
binned94414542binned
biped104718832b_iped
birded104414302birded
birled94416992birled
birred94713202birred
blind86319322blin_d
blinded114810022blinded
blinked144010012blinked
boiled95020952boiled
boinked14457042boinked
boned85133242b_oned
braced115420602braced
braided114013212braided
brailed103914012brailed
braised104014802braised
braked135318692braked
brand85124492bran_d
branded114414102branded
branned104311692branned
braved124817442braved
brayed124615782brayed
brazed184717082brazed
bred75130972br__ed
breed85526692br_eed
brewed125411872brewed
briard94311292briard
bribe94820782bribe_
bribee104316362bribee
briber104714042briber
bribes105918532bribes
bricked164312062bricked
bride86425532bride_
brides94423512brides
bridged12339032bridged
bridled113611142bridled
brie65837902bri_e_
brief105422602bri_ef
briefed1335742briefed
brier74527402bri_er
bries74942152bri_es
brimmed14386782brimmed
brin67038192brin__
brindled12407852brindled
briners94315632briners
bring85528502brin_g
bringer104213352bringer
brings94618432brings
brinier93613472brinier
brinies93317912brinies
brink116122002brin_k
brinks124616312brinks
brins75533972brin_s
briny104719662brin_y
brises84927612brises
brisked144210002brisked
broiled103811422broiled
bronzed19308212bronzed
browed125216392browed
browned134710972browned
bruised10389502bruised
bruited104110352bruited
brunet84419292brunet
bruted95113262bruted
bruxed16466982bruxed
buried94822372buri_ed
burned95818962burned
bylined1335852bylined
chined125620062chined
coined94523602coined
craned96121652craned
cried84624282cri_ed
cringed113312402cringed
dined76431992_dined
drained93713252drained
dried75321382dri_ed
droned84616862droned
dwined114610212dwined
ermined10410602ermined
fined94930502_fined
foined105915012foined
fried95322912fri_ed
friend10388932friend
fringed123611522fringed
frized193510682frized
gained84617462gained
girned84010512girned
grained93814272grained
grided95117042grided
grimed104714092grimed
grind75917562grin_d
grinded104210632grinded
grinned9378552grinned
griped104114712griped
groined92710812groined
irised73913152irised
ironed74916012ironed
joined144613072joined
kirned11408622kirned
lined64934642_lined
mined85333352_mined
opined95113852opined
pained95622852pained
peined94918842peined
pined85935322_pined
priced115018882priced
prided103618032prided
pried84426862pri_ed
primed115118912primed
prinked143412162prinked
printed104016372printed
prised94322202prised
prized184415392prized
pruned93413112pruned
rained75024602rained
reined74425522reined
riced85825542_riced
riled65833252_riled
rimed84826372_rimed
rind56535602_rin_d
rinded84418982_rinded
ringed84623842_ringed
rinsed75016352_rinsed
riped85226432_riped
rived94825612_rived
ruined74813322ruined
sained75424242sained
seined74023062seined
shined104620782shined
shrined114112412shrined
spined95423942spined
tined65434532_tined
trained84117202trained
triced95518672triced
tried65026912tri_ed
trine54734602trine_
trines64132562trines
twined104413122twined
urine55026592urine_
urines64724122urines
veined104413912veined
vined95626152_vined
whined134715202whined
wined94434182_wined
wried95518562wri_ed
wringed123710192wringed

Search took 3 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.1261418182.5
2DLD Change Limit825511712.14038575.2
3Display Results1711710.0463717.4
 (SQL Overall)1786911712.31277288.5
 
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.