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

151 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
blast7653257(None) 
bast66362411b_ast
beast76338641beast
blase75524231blase
blasts85116771blasts
blasty115611051blasty
blat66550951bla_t
blats75132501blats
blest76431721blest
boast75935701boast
clast76030581clast
last46260321_last
oblast8613661oblast
ablaut8313262ablaut
ablest84721832ablest
alant55742292alant
alas46358122alas_
alist56136782alist
avast85519362avast
baas66844672baas_
baht96740012b_aht
bait66556002b_ait
balas76937212balas_
ballast9313992ballast
bals66354042bals_
balsa77920412balsa
bas58681752b_as_
base64847022b_ase
bash915240162b_ash
bask105131422b_ask
bass66146782b_ass
baste74829982b_aste
basts75936932b_asts
bat510988952b_a_t
bats66962332b_ats
batt65053872b_att
beasts84519722beasts
beat66168302bea_t
beats76042242beats
beaut75135212beaut
best66355322b_est
bias64738152bias_
blab86629132bla_b
blabs95619632blabs
black134719072black
blade85923332blade
blae66134642bla_e
blaff135216482blaff
blah98625062bla_h
blahs105616512blahs
blain75421792blain
blam86131702bla_m
blame95625492blame
blams95023852blams
bland85320452bland
blank115418552blank
blare75826232blare
blasted104213472blasted
blaster94017302blaster
blastie92411392blastie
blate75933782blate
blaw97026722bla_w
blawn106813702blawn
blaws105620462blaws
blaze165520832blaze
bleat75737002bleat
bleats85518612bleats
blent76230952blent
bless75917812bless
blet66247672bl_et
blets75324942blets
bliss75616912bliss
bloat75229922bloat
bloats85215762bloats
blot65842322bl_ot
blots75626172blots
bluest84016482bluest
bluet75631192bluet
blunt75525022blunt
blurt77625622blurt
blush105115312blush
boart78835932boart
boas66150832boas_
boasts85017922boasts
boat66360312boa_t
boats75635152boats
bolas74733762bolas_
boost75132472boost
bract96332722bract
brant74742172brant
bras65746452bras_
brash106221562brash
brass75428022brass
brat66055542bra_t
brats75336012brats
breast8319632breast
burst75332242burst
bust65947782b_ust
bypast13117372bypast
cast67159902_cast
clapt98027172clapt
clash106219032clash
clasp95517192clasp
claspt104513412claspt
class75525482class
clasts84817292clasts
coast75236262coast
east46659102_east
fast77052312_fast
feast85932722feast
flash115716212flash
flask125512422flask
flat77147822fla_t
flats86429742flats
gast56052562_gast
ghast95621222ghast
glass65518132glass
glost65422932glost
hast76259482_hast
las37281472_las_
lase46148512_lase
lash76539652_lash
lass47444542_lass
lasts57731262_lasts
lat37593402_la_t
lats45962702_lats
least56134882least
lest46956322_lest
list47055342_list
lost47951492_lost
lust47442602_lust
mast65959952_mast
oast47156322_oast
oblasti945942oblasti
oblasts947292oblasts
past65959012_past
plait75631572plait
plant75437112plant
plash104616562plash
plasm94114632plasm
plat66048872pla_t
plats75531372plats
roast56230142roast
slant55238702slant
slash84719682slash
slat46959022sla_t
slats55436902slats
toast55831012toast
vast75045122_vast
wast75655852_wast
yeast85327942yeast

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.0931921408.6
2DLD Change Limit538001511.70331591.3
3Display Results1511510.0305033.3
 (SQL Overall)1786911511.82697859.3
 
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.