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

86 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
browns11641563(None) 
brawns115614081brawns
brown105619531brown_
browny144510041browny
brows105425981brow_s
crowns115615111crowns
drowns105612331drowns
frowns126011391frowns
barons85025382baro_ns
blown105716672blown_
blows105423832blow_s
boons75031912b_oons
borons85520542borons
bowls106121432b_owls
bows96242862b_ow_s
brains85125472brains
brans75437432br_ans
brawls115214332brawls
brawn106018562brawn_
brawny144710602brawny
braws106425192braw_s
brens75823362br_ens
brewis11469982brewis
brews105617072brew_s
brins75533972br_ins
broads94515152broads
brocks145214152brocks
brogans1049662brogans
broils84114172broils
bromes104719762bromes
bromins112513782bromins
bromos104213312bromos
bronc91714342bro_nc
broncs101611152broncs
broods95416382broods
brooks125813882brooks
brooms104915872brooms
broos75126412bro_os
bros65635662bro__s
broses86524402broses
broths115013922broths
brow97228442brow__
browed125216392browed
browned134710972browned
browner124911642browner
brownest1398892brownest
brownie12178432brownie
brownies13189612brownies
brownish1645642brownish
browse115713852browse
browses124712692browses
bruins86014952bruins
clowns114810112clowns
croons85418422croons
crowds124910762crowds
crown105620082crown_
crows105727312crow_s
downs94918572_downs
drown95515822drown_
drownd11478312drownd
drownds12346152drownds
embrowns1544042embrowns
frons86124042fro_ns
frown115415972frown_
frows116623102frow_s
gowns95115102_gowns
groans74815062groans
groins73917202groins
growls104711112growls
grown95317352grown_
grows95523922grow_s
imbrowns1543262imbrowns
irons55324132iro_ns
knowns13426442knowns
kroons103711242kroons
owns76819582__owns
prawns11509022prawns
prowls115511082prowls
prows106327012prow_s
roans54926442_roans
rowans95715342_rowans
rowens94515302_rowens
rows75941752_row_s
towns86018882_towns
trows88826182trow_s
vrows116115262vrow_s

Search took 3 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 Filter178691825510.376475242.0
2DLD Change Limit82551862.57632046.2
3Display Results86860.0332606.1
 (SQL Overall)178691862.98559863.0
 
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.