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

260 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
bash91524016(None) 
abash106016511abash
ash67944601_ash
bach116131391bach
bah87755351ba_h
bas58681751bas_
base64847021base
bask105131421bask
bass66146781bass
bast66362411bast
bath95940081bath
bosh96328971bosh
brash106221561brash
bush96630711bush
cash96636281cash
dash87031631dash
fash107232291fash
gash86833021gash
hash106936501hash
lash76539651lash
mash96039391mash
pash95638131pash
rash76039931rash
sash77235301sash
wash106033811wash
aah616252962_aah
aahs716428562aahs
aas310975392aas_
abas68642082abas_
abase76023482abase
abs59356072abs_
ah513868792_a_h
ahs68644822_ahs
as211083072_as_
ashy107717352_ashy
ask77130702_ask
asp57235342_asp
ass37844062_ass
awash116613162awash
ba49962342ba__
baa510650422ba_a
baal67033112baal
baas66844672baas
baba88828342baba
babe86835812babe
babu85829222babu
baby116723672baby
back125535762back
bad67763152ba_d
bade75140882bade
bads77048862bads
baff124632262baff
bag67059222ba_g
bags76645502bags
baht96740012baht
bail65042802bail
bait66556002bait
baith108023132baith
bake105637512bake
bal56662722ba_l
bald76432902bald
bale66353842bale
balk105132222balk
ball66043322ball
balm85534202balm
bals66354042bals
balsa77920412balsa
bam78560142ba_m
bams87044452bams
ban58366832ba_n
band76740902band
bane65250422bane
bang74836992bang
bani65334952bani
banish111416042banish
bank105835742bank
bans66555132bans
bap76455842ba_p
baps86040842baps
bar58070552ba_r
barb85240062barb
bard75648862bard
bare65460522bare
barf95844402barf
bark106242152bark
barm86739602barm
barn66444642barn
bars66564092bars
basal75722282basal
based85331582based
baser74828922baser
bases75644352bases
bashaw14349302bashaw
bashed126225702bashed
basher115123812basher
bashes115631392bashes
basic96220522basic
basil75122272basil
basin75026922basin
basis75429862basis
basks115621762basks
bassi77019322bassi
basso76017282basso
bassy1012917102bassy
baste74829982baste
basts75936932basts
bat510988952ba_t
batch124620102batch
bate66552422bate
bathe105822882bathe
baths105922922baths
bats66962332bats
batt65053872batt
baud74928422baud
bawd105520842bawd
bawl95326062bawl
bay89661642ba_y
bays97143912bays
beach124623892beach
beast76338642beast
bes56557432bes_
best66355322best
beth96629232beth
bias64738152bias_
bis56860652bis_
bise66437092bise
bisk106523342bisk
blah98625062blah
blahs105616512blahs
blase75524232blase
blast76532572blast
blush105115312blush
boas66150832boas_
boast75935702boast
bos57966812bos_
bosk105825732bosk
boss65938342boss
both96533432both
brach126123302brach
bras65746452bras_
brashy145210592brashy
brass75428022brass
brush105917472brush
bus56950972bus_
bushy135416682bushy
busk105429222busk
buss65134912buss
bust65947782bust
busy94727172busy
bys85229462bys_
caph116623292caph
casa65630862casa
case65848082case
cask105626432cask
cast67159902cast
clash106219032clash
cosh96127622cosh
crash109120012crash
dah78148982da_h
dahs88231812dahs
dashi95013112dashi
dashy125612382dashy
deash95617242deash
dish86328332dish
each95530582each
ease45042332ease
east46659102east
easy76224492easy
eath75735662eath
fas68262932fas_
fast77052312fast
fish106926272fish
flash115716212flash
gas48870252gas_
gasp76227332gasp
gast56052562gast
gnash9449832gnash
gosh86123422gosh
gush85424002gush
hah910655222ha_h
hahs108333362hahs
harsh116418052harsh
has67372652has_
hasp96627292hasp
hast76259482hast
hath105933912hath
hush105224112hush
josh145117612josh
kaph135815752kaph
kas77058582kas_
kasha124710722kasha
lakh114919952lakh
las37281472las_
lase46148512lase
lass47444542lass
last46260322last
lath76640382lath
leash85519212leash
lush75327692lush
mach116134472mach
marsh105320852marsh
mas58175812mas_
masa65034712masa
mashy136016502mashy
mask105227352mask
mass66044932mass
mast65959952mast
math95437442math
mesh96823002mesh
mosh95227602mosh
mush94929122mush
nah69847002na_h
nosh76223542nosh
oast47156322oast
oath76132152oath
obas65730932obas_
pah88853592pa_h
pas58775742pas_
pase65346862pase
pasha105417182pasha
pass65239952pass
past65959012past
path99134912path
pish96127912pish
plash104616562plash
posh95427322posh
push95526622push
quash174512162quash
rah68052402ra_h
ras37575392ras_
rase46149982rase
rasp66029162rasp
rath76037662rath
resh76523452resh
rush76628182rush
sass45035622sass
sh56828522__sh
slash84719682slash
smash104814432smash
snash84815672snash
stash84916972stash
swash116316752swash
tach96132752tach
tas38477102tas_
task85326652task
tass45640572tass
tosh74826812tosh
trash86119762trash
tush74523902tush
vas67755772vas_
vasa76522972vasa
vase75629652vase
vast75045122vast
was68767562was_
washy145911842washy
wasp95626852wasp
wast75655852wast
wish107228732wish
yah99046352ya_h
zas126946832zas_

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 Filter178691298720.0802233637.5
2DLD Change Limit298722601.59318752.0
3Display Results2602600.1232113.8
 (SQL Overall)1786912601.79699493.9
 
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.