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

118 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
blaster9401730(None) 
baster85333591b_aster
blasted104213471blasted
blasters104116141blasters
blastier10249491blastier
blatter94415651blatter
blister94415311blister
bluster94215311bluster
boaster94616431boaster
laster64830631_laster
plaster93318691plaster
alastor739652alastor
aster55434892__aster
baiter84422552b_aiter
ballaster1145972ballaster
baluster1037052baluster
banter84825332b_anter
barter85525372b_arter
baser74828922b_as_er
basher115123812b_asher
baste74829982b_aste_
basted95227232b_asted
basters94930302b_asters
bastes85330382b_astes
batter84928872b_atter
beater84729392bea_ter
bister84922762b_ister
blabber10418922blabber
blacker154513512blacker
bladder11429152bladder
blader93618582bla_der
blamer104417142bla_mer
blander103715162blander
blanker134612022blanker
blase75524232blas_e_
blast76532572blast__
blastema1244682blastema
blastie92411392blastie
blasties102113622blasties
blasts85116772blast_s
blasty115611052blast_y
blate75933782bla_te_
blather125314202blather
blatted104812712blatted
blatters104414092blatters
blazer174414022bla_zer
bleater94515302bleater
blesser9329292blesser
blisters104015082blisters
blistery13418712blistery
bloater94013422bloater
blotter94612852blotter
blunter94512032blunter
blurter9419832blurter
blusher124113112blusher
blusters104413892blusters
blustery13368002blustery
boasted104113742boasted
boasters103915662boasters
boater84622092boa_ter
bolster93713422bolster
booster94314552booster
brasher124515242brasher
brasier94516752brasier
burster9310292burster
buster84726492b_uster
caster85232572_caster
chaster124718502chaster
clasher124615512clasher
clasper113811862clasper
classer93614612classer
clatter94014972clatter
cluster94013332cluster
clyster12317452clyster
coaster94219042coaster
diaster82813312diaster
easter65027982_easter
elater64724202ela_ter
faster94625772_faster
feaster10812982feaster
flasher133914062flasher
flatter103815962flatter
fluster103913062fluster
gaster75027352_gaster
glister84013342glister
klister113410642klister
lamster9109912_lamster
laser54633322_las_er
lasher94824532_lasher
lasted74323602_lasted
lasters75627692_lasters
later54843922_la_ter
latter65027892_latter
lister64527252_lister
luster64023672_luster
master84831342_master
oldster896572oldster
oleaster837262oleaster
paster85734372_paster
piaster93012882piaster
pilaster1038162pilaster
plaister1068012plaister
plaiter93615392plaiter
planter94017802planter
plasher124215032plasher
plasters103518132plasters
plastery13279702plastery
plater84427692pla_ter
platter93917412platter
raster64731442_raster
roaster74116662roaster
slasher104515332slasher
slater64429182sla_ter
taster64930572_taster
toaster74414462toaster
ulster63712102ul_ster
vaster94521022_vaster
waster95228942_waster

Search took 4 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 Filter1786911076710.1231452772.4
2DLD Change Limit1076711183.25033129.5
3Display Results1181180.0462565.2
 (SQL Overall)1786911183.41952264.1
 
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.