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

291 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
brins7553397(None) 
bins66548241b_ins
brains85125471brains
brans75437431brans
brens75823361brens
bries74942151bries
brigs85823221brigs
brims94721621brims
brin67038191brin_
brine75132271brine
brines85028851brines
bring85528501bring
brings94618431brings
brink116122001brink
brinks124616311brinks
briny104719661briny
brios74725721brios
bris65539611bri_s
briss75824271briss
brits76433081brits
bruins86014951bruins
burins84221891burins
grins65427221grins
rins46153191_rins
ablins8316192ablins
abris75722602abri_s
ains46158882_ains
airns55521032airns
amins75534312amins
arias55438022arias
arils58732202arils
ayins85321612ayins
bails75933522bails
bairns86710872bairns
baits76630582baits
banns75321232banns
bans66555132b_ans
baring95135852baring
barns76335142barns
barons85025382barons
basins85722762basins
beans75734692beans
begins94415302begins
being84920502being
beings94613032beings
bens65945702b_ens
berlins93216012berlins
bias64738152b_ias
bibs84830972b_ibs
bids75838422b_ids
bigs76235012b_igs
bin56658632b_in_
bind76234502b_ind
binds86627472b_inds
bine66650852b_ine
bines76946792b_ines
bint67355032b_int
bints76130182b_ints
bios66335312b_ios
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
bis56860652b_i_s
bits66148152b_its
blains84516372blains
blin67228172blin_
blind86319322blind
blinds95111612blinds
blini75519272blini
blinis85313682blinis
blink115720142blink
blinks124613572blinks
blips95615782blips
bliss75616912bliss
boils75427192boils
boing84725552boing
boings96416872boings
boink115516332boink
boinks125211272boinks
boons75031912boons
boring94724872boring
borings103614242borings
borons85520542borons
brads85528292brads
braes75735052braes
brags85625102brags
braids95015682braids
brails84621292brails
brain76229382brain_
brainy114815642brainy
bran65740382bran_
brand85124492brand
brands95118942brands
brank115222282brank
branks124817382branks
brant74742172brant
brants85723052brants
bras65746452br_as
brass75428022brass
brats75336012brats
brawns115614082brawns
braws106425192braws
brays106723112brays
brees75632552brees
bren65629562bren_
brent75734132brent
brents84717272brents
brews105617072brews
briar75718152briar
briars84814822briars
bribe94820772bribe
bribes105918532bribes
brick134618152brick
bricks144614622bricks
bride86425532bride
brides94423512brides
brie65837902bri_e
brief105422592brief
briefs115510072briefs
brier74527402brier
briers85319732briers
brig76528032bri_g
brill74819952brill
brills84916292brills
brim85629372bri_m
brined95118412brined
briner84519042briner
briners94315632briners
brinies93317912brinies
brinish1239962brinish
brio65432492bri_o
briony1149042briony
brises84927612brises
brisk115615982brisk
brisks124611402brisks
brit66350152bri_t
brith104924372brith
briths115113862briths
britt75732232britt
britts84813442britts
broils84114172broils
bromins112513782bromins
bronc91714342bronc
broncs101611152broncs
broos75126412broos
bros65635662br_os
browns116415632browns
brows105425982brows
brucins1158002brucins
bruin75818332bruin_
bruits85714452bruits
brung84613912brung
brunt75728752brunt
brunts85215452brunts
bruts75922952bruts
bunns74718292bunns
buns66243722b_uns
burans85019302burans
buries84633272buries
burin75626062burin_
burns74926772burns
cains75334302cains
chins105631462chins
coins75834552coins
cribs94516742cribs
cries75438402cries
cris66233432cri_s
crits75527572crits
dins56652042_dins
djins1368452djins
drains73719402drains
dribs85115052dribs
dries64733672dries
drink106816382drink
drinks116810712drinks
drips85417232drips
erns45428222er_ns
fibrins1238632fibrins
fins75849092_fins
firns86018542firns
foins85523382foins
fries85535602fries
frigs96019272frigs
frits86129102frits
frons86124042frons
gains65729512gains
gins55543952_gins
girns64516802girns
grains74223092grains
grans64832542grans
grids75321392grids
grigs75318192grigs
grin55733722grin_
grind75917562grind
grinds84511842grinds
grips85520132grips
grits65529582grits
groins73917202groins
hins76447992_hins
ins35945602__ins
irids66417762irids
iring66025412iring
iris45732542iri_s
irons55324132irons
jins115635012_jins
joins125818412joins
kains96125642kains
kins85747902_kins
kirns95315452kirns
kris86423602kri_s
lins47059052_lins
loins56728422loins
mains75635092mains
mirins83918892mirins
orcins83313432orcins
ornis54616772ornis
orpins83614162orpins
pains75138282pains
peins76128062peins
pins65558452_pins
pirns76020092pirns
pries74339532pries
prigs85219702prigs
prims95425932prims
prink114719672prink
prinks124315382prinks
print74837462print
prints84320102prints
prions84317782prions
priss74623892priss
purins83722652purins
pyins105815862pyins
quins144819852quins
rains55140232rains
reins56234562reins
rias45540592_rias
ribs65833012_ribs
rids56539542_rids
rifs74929002_rifs
rigs55137592_rigs
rims65936302_rims
rin36663182_rin_
rind56535602_rind
rinds64826142_rinds
ring56541152_ring
rings65029172_rings
rink87736992_rink
rinks94827102_rinks
rinse54820972_rinse
rips66237432_rips
ruins55822032ruins
runs46438072_runs
sains55639972sains
sarins63932622sarins
serins64029672serins
shins85131042shins
sins46755272_sins
skins94723462skins
spins75327982spins
sris45434152sri_s
tains54936322tains
thins85826322thins
tins45251302_tins
trains64725342trains
trans54933042trans
triens65417542triens
tries55742812tries
trigs65423062trigs
trims75021472trims
trine54734602trine
trines64132562trines
trios55528092trios
trips74923362trips
twins85118982twins
urine55026592urine
urines64724122urines
urns46323892ur_ns
veins84620492veins
wains86930862wains
whins114922332whins
wins75949172_wins
wrens85016242wrens
wries85827742wries
wring95920712wring
wrings104012972wrings
writs86624382writs
yins75335122_yins
zeins144715392zeins
zins135735002_zins

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 Filter178691538000.0931921408.6
2DLD Change Limit538002913.00017933.3
3Display Results2912910.1561865.4
 (SQL Overall)1786912913.24954998.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.