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

207 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
baste7482998(None) 
base64847021bas_e
bast66362411bast_
basted95227231basted
baster85333591baster
bastes85330381bastes
basts75936931basts
bate66552421ba_te
caste75932361caste
haste85927861haste
paste74932951paste
taste55127231taste
waste86125051waste
abase76023482abas_e
abate76627842abate
ante46538902_ante
aster55434892_aster
ate37059242_a_te
babe86835812ba_be
bade75140882ba_de
badge94819682badge
baht96740012baht_
bahts105617802bahts
bait66556002bait_
baited95319242baited
baiter84422552baiter
baith108023132baith
baits76630582baits
baize164717392baize
bake105637512ba_ke
bale66353842ba_le
bane65250422ba_ne
banter84825332banter
banty106624002banty
barbe95328282barbe
barde85330772barde
bare65460522ba_re
barge85631022barge
barite84224812barite
barre75929542barre
barter85525372barter
barye105021492barye
baryte115312882baryte
bas58681752bas__
basal75722282basal
based85331582based
baser74828922baser
bases75644352bases
bash915240162bas_h
bashed126225702bashed
basher115123812basher
bashes115631392bashes
basic96220522basic
basil75122272basil
basin75026922basin
basis75429862basis
bask105131422bas_k
basked135218602basked
basket125722912basket
basks115621762basks
basque17259082basque
bass66146782bas_s
basses85428302basses
basset85225382basset
bassi77019322bassi
basso76017282basso
bassy1012917102bassy
basters94930302basters
bastile9313912bastile
bat510988952ba_t_
bated85935532ba_ted
bates75846342ba_tes
bath95940082ba_th
bathe105822882bathe
batiste939742batiste
bats66962332ba_ts
batt65053872ba_tt
batted95623652batted
batten85217122batten
batter84928872batter
battle85217862battle
batts76727562batts
battu75216612battu
battue84311002battue
batty105422242batty
bawtie113812142bawtie
bawty135614102bawty
beast76338642beast_
beastie92412432beastie
beasts84519722beasts
beset76739132beset
best66355322best_
bested94922752bested
bests75932612bests
bise66437092bis_e
bister84922762bister
bistre83815022bistre
bite66546992b_ite
blase75524232blas_e
blast76532572blast_
blasted104213472blasted
blaster94017302blaster
blastie92411392blastie
blasts85116772blasts
blasty115611052blasty
blate75933782blate
blite76225352blite
boast75935702boast_
boasted104113742boasted
boaster94616432boaster
boasts85017922boasts
boite74426322boite
brute75321782brute
bust65947782bust_
busted95123152busted
buster84726492buster
bustle84015482bustle
busts75227692busts
busty105621012busty
bute66739672b_ute
butte74924292butte
byte96521812b_yte
carte75940422carte
case65848082cas_e
cast67159902cast_
caster85232572caster
castes85631862castes
castle84918962castle
casts77237792casts
cate66254592ca_te
chaste114617392chaste
date56443322da_te
ease45042332eas_e
east46659102east_
easter65027982easter
easts57530322easts
fast77052312fast_
fasted105320952fasted
fasten95114892fasten
faster94625772faster
fasts86429682fasts
fate75444282fa_te
gast56052562gast_
gasted84821582gasted
gaster75027352gaster
gasts66628632gasts
gate55746572ga_te
geste65920692geste
hast76259482hast_
hasted105125282hasted
hasten95718562hasten
hastes95727072hastes
hasty115718762hasty
hate78450172ha_te
haute89521612haute
lase46148512las_e
last46260322last_
lasted74323602lasted
laster64830632laster
lasts57731262lasts
late47560482la_te
latte55426302latte
masse75125292masse
mast65959952mast_
masted94025802masted
master84831342master
masts77035762masts
mate65154212ma_te
matte75626842matte
moste75925082moste
nasty85717282nasty
oast47156322oast_
oasts56529182oasts
pase65346862pas_e
passe75525692passe
past65959012past_
pasta76624532pasta
pasted94426902pasted
pastel85918712pastel
paster85734372paster
pastes85233912pastes
pastie85525522pastie
pasts75936502pasts
pasty105725052pasty
pate65350462pa_te
piste75824602piste
rase46149982ras_e
raster64731442raster
rate45458762ra_te
sate45556102sa_te
saute55028082saute
tasse54821842tasse
tasted74123972tasted
taster64930572taster
tastes64126422tastes
tasty84820312tasty
tate44748602ta_te
vase75629652vas_e
vast75045122vast_
vaster94521022vaster
vasts86423772vasts
vasty116215922vasty
wast75655852wast_
wasted104423022wasted
waster95228942waster
wastes96224882wastes
wasts87433672wasts

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 Filter178691538000.1701051123.5
2DLD Change Limit538002073.47015504.3
3Display Results2072070.1101881.8
 (SQL Overall)1786912073.75047650.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.