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

142 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
brash10622156(None) 
bash915240161b_ash
brach126123301brach
bras65746451bras_
brashy145210591brashy
brass75428021brass
brush105917471brush
crash109120011crash
rash76039931_rash
trash86119761trash
abash106016512abash
ash67944602__ash
awash116613162awash
baas66844672baas_
bach116131392b_ach
bah87755352b_a_h
bars66564092bars_
bas58681752b_as_
base64847022b_ase
bask105131422b_ask
bass66146782b_ass
bast66362412b_ast
bath95940082b_ath
beach124623892beach
beast76338642beast
bias64738162bias_
blah98625062bla_h
blahs105616512blahs
blase75524232blase
blast76532572blast
blush105115312blush
boas66150832boas_
boast75935702boast
boras75938302boras_
bosh96328972b_osh
bra56339462bra__
brace95629272brace
brachs134415752brachs
bract96332722bract
brad75234342bra_d
brads85528292brads
brae65639112bra_e
braes75735052braes
brag75229722bra_g
brags85625102brags
braid85822262braid
brail75525552brail
brain76229382brain
braise84318752braise
brake116025342brake
braky145015812braky
bran65740382bra_n
branch134014772branch
brand85124492brand
brank115222282brank
brans75437432brans
brant74742172brant
brasher124515242brasher
brashes124518462brashes
brashly15427612brashly
brasil8713862brasil
brassy11509232brassy
brat66055542bra_t
brats75336012brats
brava106414792brava
brave104925502brave
bravi104715752bravi
bravo105214342bravo
braw94829562bra_w
brawl106217962brawl
brawn106018562brawn
braws106425192braws
braxy175410892braxy
bray95232902bra_y
brays106723112brays
braza165214252braza
braze165423452braze
breach134213722breach
breast8319632breast
breath113916262breath
bris65539612bris_
brisk115615982brisk
briss75824272briss
brith104924372brith
broach133611112broach
bros65635662bros_
brose75227032brose
brosy106115382brosy
broth106521092broth
brugh115414292brugh
brushy14468262brushy
brusk114912432brusk
buras74736302buras_
bush96630712b_ush
cash96636282_cash
clash106219032clash
crass76328042crass
crush106815992crush
dash87031632_dash
deash95617242deash
eras45441502eras_
erase54925492erase
fash107232292_fash
flash115716212flash
frass85321122frass
fresh115012202fresh
frosh115713402frosh
gash86833022_gash
gnash9449832gnash
graph115315612graph
grasp84814482grasp
grass66125202grass
harsh116418052harsh
hash106936502_hash
lash76539652_lash
leash85519212leash
marsh105320852marsh
mash96039402_mash
orach105219232orach
pash95638132_pash
plash104616562plash
prase76128752prase
quash174512162quash
rah68052402_ra_h
ras37575392_ras_
rase46149982_rase
rasp66029162_rasp
rath76037662_rath
resh76523452_resh
rush76628182_rush
sash77235302_sash
slash84719682slash
smash104814432smash
snash84815672snash
stash84916972stash
swash116316752swash
thrash12258362thrash
trashy12509052trashy
trass56226472trass
urase54624692urase
wash106033812_wash
wrath115715872wrath

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 Limit538001421.39038705.0
3Display Results1421420.0463087.0
 (SQL Overall)1786911421.749102167.5
 
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.