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

125 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
briny10471966(None) 
brainy114815641brainy
brin67038191brin_
brine75132271brine
bring85528501bring
brink116122001brink
brins75533971brins
briony1149041briony
baring95135852baring
barny105821732barny
barony115915302barony
beigy111110582beigy
being84920502being
benny105217362benny
bin56658642b_in_
bind76234512b_ind
bine66650862b_ine
bins66548252b_ins
bint67355042b_int
blimy125212822blimy
blin67228172blin_
blind86319322blind
blini75519272blini
blink115720142blink
boing84725552boing
boink115516332boink
bonny105816622bonny
bony96732082b_ony
boring94724872boring
brain76229382brain_
brains85125472brains
braky145015812braky
bran65740382bran_
brand85124492brand
brandy124712062brandy
brank115222282brank
branny115111832branny
brans75437432brans
brant74742172brant
brawny144710602brawny
braxy175410892braxy
bray95232902br_ay
bren65629562bren_
brens75823362brens
brent75734132brent
briar75718152briar
briary114912002briary
bribe94820782bribe
brick134618152brick
bricky17489092bricky
bride86425532bride
brie65837902bri_e
brief105422602brief
brier74527402brier
briery114510772briery
bries74942152bries
brig76528032bri_g
brigs85823222brigs
brill74819952brill
brim85629372bri_m
brims94721622brims
brined95118412brined
briner84519042briner
brines85028852brines
brings94618432brings
brinks124616312brinks
brio65432492bri_o
brios74725722brios
bris65539612bri_s
brisk115615982brisk
briss75824272briss
brit66350152bri_t
brith104924372brith
brits76433082brits
britt75732232britt
bronc91714342bronc
bronzy20306712bronzy
brosy106115382brosy
browny144510042browny
bruin75818332bruin_
bruins86014952bruins
brung84613912brung
brunt75728752brunt
bryony1435832bryony
bunny104715802bunny
burin75626062burin_
burins84221892burins
crony105918672crony
drily95816522drily
drink106816382drink
fringy13309262fringy
grainy103914212grainy
grimy114312602grimy
grin55733722grin_
grind75917562grind
grins65427222grins
gripy115115252gripy
iring66025422iring
irony85015902irony
liny78141322_liny
meiny104015412meiny
piny911838352_piny
pricy124814562pricy
prink114719672prink
print74837462print
privy13439832privy
rainy85921082rainy
rimy96621282_rimy
rin36663182_rin_
rind56535602_rind
rindy95717392_rindy
ring56541152_ring
rink87736992_rink
rins46153192_rins
shiny115122142shiny
spiny104921302spiny
tiny76134632_tiny
trine54734602trine
twiny116012812twiny
urine55026602urine
veiny115414362veiny
viny106025952_viny
whiny144915572whiny
winy107034322_winy
wring95920712wring

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.313570897.8
2DLD Change Limit538001251.62333148.5
3Display Results1251250.0333787.9
 (SQL Overall)1786911251.96990752.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.