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

187 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
brios7472572(None) 
bios66335321b_ios
biros75325131biros
bries74942151bries
brigs85823221brigs
brims94721621brims
brins75533971brins
brio65432491brio_
bris65539611bri_s
briss75824271briss
brits76433081brits
broos75126411broos
bros65635661br_os
trios55528091trios
abris75722602abri_s
adios65822862adios
agios65919862agios
arias55438022arias
arils58732202arils
ariose64818722ariose
ariosi64313032ariosi
arioso64312402arioso
arvos86015662arvos
bails75933522bails
baits76630582baits
barrios9310772barrios
bias64738162b_ias
bibs84830992b_ibs
bids75838432b_ids
bigos85020012bigos
bigs76235022b_igs
bins66548252b_ins
bio57846082b_io_
biog76122322b_iog
biogs85016112b_iogs
birds85421332birds
birks114920302birks
birls74023162birls
biro66131212biro_
birrs74917102birrs
bis56860662b_i_s
bits66148162b_its
blips95615782blips
bliss75616912bliss
bohos105618252bohos
boils75427192boils
bolos75531372bolos
boos67955032b_oos
bos57966812b__os
boyos105418282boyos
bozos165216862bozos
brads85528292brads
braes75735052braes
brags85625102brags
braids95015682braids
brails84621292brails
brains85125472brains
brans75437432brans
bras65746452br_as
brass75428022brass
brats75336012brats
bravos114711392bravos
braws106425192braws
brays106723112brays
brees75632552brees
brens75823362brens
brews105617072brews
briar75718152briar
briars84814822briars
bribe94820782bribe
bribes105918532bribes
brick134618152brick
bricks144614622bricks
bride86425532bride
brides94423512brides
brie65837902bri_e
brief105422602brief
briefs115510072briefs
brier74527402brier
briers85319732briers
brig76528032bri_g
brill74819952brill
brillos9369172brillos
brills84916292brills
brim85629372bri_m
brin67038192bri_n
brine75132272brine
brines85028852brines
bring85528502bring
brings94618432brings
brink116122002brink
brinks124616312brinks
briny104719662briny
briony1149042briony
brises84927612brises
brisk115615982brisk
brisks124611402brisks
brit66350152bri_t
brith104924372brith
briths115113862briths
britt75732232britt
britts84813442britts
bro56236602br_o_
broil74918222broil
broils84114172broils
bromos104213312bromos
broo65129822br_oo
brood84620242brood
broods95416382broods
brook114717762brook
brooks125813882brooks
broom95022212broom
brooms104915872brooms
brose75227032br_ose
brosy106115382br_osy
brow97228442br_ow
brows105425982brows
bruins86014952bruins
bruits85714452bruits
bruts75922952bruts
buries84633272buries
burins84221892burins
burros85114992burros
cribs94516752cribs
cries75438402cries
cris66233432cri_s
crits75527572crits
curios83218332curios
dribs85115062dribs
dries64733672dries
drips85417232drips
eros45238452er_os
fries85535602fries
frigs96019272frigs
frits86129102frits
giros65722652giros
grids75321392grids
grigs75318192grigs
grins65427222grins
griot65328412griot
griots74713642griots
grips85520132grips
grits65529582grits
irids66417772irids
iris45732552iri_s
kris86423602kri_s
olios54520852olios
ordos65216202ordos
orzos143311252orzos
praos74923562praos
pries74339532pries
prigs85219702prigs
primos104514422primos
prims95425932prims
prion75119992prion
prions84317782prions
prior74316172prior
priors83914482priors
priss74623892priss
pros65742782pr_os
rhos76319062_rhos
rias45540592_rias
ribs65833022_ribs
rids56539542_rids
rifs74929002_rifs
rigs55137592_rigs
rims65936302_rims
rins46153192_rins
riot45947212_riot
riots54922012_riots
rips66237432_rips
sris45434152sri_s
tiros54524892tiros
tries55742812tries
trigos74214172trigos
trigs65423062trigs
trims75021472trims
trio45233342trio_
triol55521362triol
triols66117802triols
triose64715382triose
tripos84014922tripos
trips74923362trips
trois57226092trois
vibrios1235802vibrios
wries85827742wries
writs86624382writs

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.0931921408.6
2DLD Change Limit538001871.73331044.4
3Display Results1871870.0464065.2
 (SQL Overall)1786911871.87295454.6
 
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.