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 “briar” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
briar7571815(None) 
briard94311291briard
briars84814821briars
briary114912001briary
brier74527401brier
friar85414271friar
aria46245422aria_
ariary94114202ariary
arias55438022arias
bar58070552b__ar
bazar163816002bazar
bear66844642b_ear
bias64738162b_ias
bier65531832b_ier
birr66022362b_irr
blear75918682blear
boar66134292b_oar
bolar75123472bolar
boyar106013762boyar
bra56339462br_a_
brad75234342br_ad
brae65639112br_ae
brag75229722br_ag
braid85822262braid
brail75525552brail
brain76229382brain
bran65740382br_an
bras65746452br_as
brat66055542br_at
braw94829562br_aw
bray95232902br_ay
bread85523112bread
break115319402break
bream95121812bream
briards10398552briards
bribe94820782bribe
briber104714052briber
brick134618152brick
bridal9511452bridal
bride86425532bride
brie65837902bri_e
brief105422602brief
briers85319732briers
briery114510772briery
bries74942152bries
brig76528032bri_g
brigs85823222brigs
brill74819952brill
brim85629372bri_m
brims94721622brims
brin67038192bri_n
brine75132272brine
briner84519042briner
bring85528502bring
brink116122002brink
brins75533972brins
briny104719662briny
brio65432492bri_o
brios74725722brios
bris65539612bri_s
brisk115615982brisk
briss75824272briss
brit66350152bri_t
brith104924372brith
brits76433082brits
britt75732232britt
broad84817692broad
brr56921922br__r
brrr65312292br_rr
burial84117622burial
burier84324652burier
bursar85413252bursar
crier74724462crier
drear65016902drear
drier64423962drier
fiar76427332_fiar
friars93812092friars
friary124010092friary
frier85225842frier
liar47229682_liar
prier75027762prier
prior74316172prior
rear45644552_rear
ria36745502_ria_
rial45938092_rial
rias45540592_rias
roar46328572_roar
triac74116372triac
triad65217722triad
trial54926352trial
trier54328532trier
urial54823022urial
wrier84521752wrier

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 Limit53800931.62633087.3
3Display Results93930.0303100.0
 (SQL Overall)178691931.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.