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

214 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
brier7452740(None) 
bier65531831b_ier
briar75718151briar
briber104714051briber
brie65837901brie_
brief105422601brief
briers85319731briers
briery114510771briery
bries74942151bries
briner84519041briner
burier84324651burier
crier74724461crier
drier64423961drier
frier85225841frier
prier75027761prier
trier54328531trier
wrier84521751wrier
aerier64823152aerier
airer54927892airer
airier64619362airier
arider74717742arider
ariel55228972ariel
armer76924442armer
artier63419732artier
babier103515572babier
bailer85425252bailer
baiter84422552baiter
baker115629542baker
baler75635272baler
barber104419322barber
barer74535802barer
barker124822862barker
barkier133814482barkier
barmier114313042barmier
barnier93213672barnier
barrier94017732barrier
barter85525372barter
baser74828922baser
beer65635992b_eer
beerier93613022beerier
belier84423562belier
bider85728372bider
biers76225222b_iers
biker116022562biker
biner75930692biner
birder94915492birder
birler85715082birler
birr66022362b_irr
biter75030032biter
bluer74918492bluer
boiler84319272boiler
boner75133082boner
bonier84321992bonier
border94419972border
borer75131272borer
bower107328182bower
boxer145016522boxer
boxier154311742boxier
bracer104620582bracer
brae65639112brae_
braes75735052braes
braider105112992braider
brakier133812362brakier
brasier94516752brasier
braver114719042braver
brawer114216332brawer
brayer115315312brayer
brazer174917532brazer
brazier183911472brazier
bred75130972br_ed
bree67241262br_ee
breed85526692breed
brees75632552brees
bren65629562br_en
brevier1237762brevier
brew95023562br_ew
brewer114812552brewer
briard94311292briard
briars84814822briars
briary114912002briary
bribe94820782bribe
bribed115312842bribed
bribee104316362bribee
bribers114111502bribers
bribery14426492bribery
bribes105918532bribes
brick134618152brick
bride86425532bride
brides94423512brides
bridler103811072bridler
briefer1235562briefer
briefs115510072briefs
brig76528032bri_g
brigs85823222brigs
brill74819952brill
brim85629372bri_m
brimmer13348802brimmer
brims94721622brims
brin67038192bri_n
brine75132272brine
brined95118412brined
briners94315632briners
brines85028852brines
bring85528502bring
bringer104213352bringer
brinier93613472brinier
brink116122002brink
brins75533972brins
briny104719662briny
brio65432492bri_o
brios74725722brios
bris65539612bri_s
brises84927612brises
brisk115615982brisk
brisker134210292brisker
briss75824272briss
brit66350152bri_t
brith104924372brith
brits76433082brits
britt75732232britt
broider103912972broider
broiler92911752broiler
broker124314242broker
brr56921922br__r
brrr65312292br_rr
bruiser9349572bruiser
bruiter93710632bruiter
burger94020792burger
buried94822372buried
buriers94017192buriers
buries84633272buries
burker125221172burker
burler84723832burler
burlier93514412burlier
burner83819202burner
burrer83718472burrer
burrier93613552burrier
busier85219722busier
buyer105013092buyer
cried84624282cried
criers83918582criers
cries75438402cries
direr64927072direr
dried75321382dried
driers74516732driers
dries64733672dries
driver104714492driver
dryer95111462dryer
eerier64320022eerier
firer811229252firer
flier86023402flier
freer86021242freer
friar85414272friar
fried95322912fried
friers94718932friers
fries85535602fries
frizer184011282frizer
fryer115913432fryer
gorier73719372gorier
grief95319782grief
griper94114612griper
hirer85423122hirer
icier74313752icier
kier86526812_kier
lier45942462_lier
mirier83918362mirier
orbier839992orbier
order65019362order
oriel54920422oriel
ormer75218372ormer
osier53518012osier
pier66035292_pier
plier75221282plier
pricer103918292pricer
pried84426862pried
priers84521192priers
pries74339532pries
primer105118682primer
prior74316172prior
prizer174714882prizer
pryer104415312pryer
ricer74726612_ricer
rider65231302_rider
riel46432382_riel
rifer84721982_rifer
rimer75429242_rimer
riper74328402_riper
riser55431052_riser
river85731692_river
ruer46127562_ruer
shier85428942shier
skier95119592skier
slier54827242slier
spier75728032spier
sprier84119062sprier
tier44936142_tier
tried65026912tried
triers64321522triers
tries55742812tries
trimer85717152trimer
triter65120592triter
truer54916642truer
twier84713292twier
urger64116472urger
varier94619352varier
verier94620962verier
vier75428152_vier
warier93722892warier
wirer85124952wirer
wirier94215552wirier
wried95518562wried
wries85827742wries
writer94416512writer
wryer11489302wryer

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.343520965.0
2DLD Change Limit538002141.50035866.7
3Display Results2142140.0633396.8
 (SQL Overall)1786912141.90693751.8
 
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.