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

144 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
beths10551922(None) 
baths105922921baths
berths114712421berths
betas75528761betas
beth96629231beth_
bets67051441bet_s
eths76619521_eths
heths116317781heths
meths105320231meths
teths85418511teths
abets75621672abet_s
bahts105617802bahts
bates75846342bates
bath95940082bath_
bathe105822882bathe
bathes116524832bathes
bathos116215632bathos
bats66962332bat_s
batts76727562batts
beads85429502beads
beaks115326622beaks
beams95328172beams
beans75734692beans
bears75739042bears
beats76042242beats
beaus75127112beaus
becks135522012becks
beds75937782be_ds
beefs105618562beefs
beeps95320972beeps
beers75628392beers
bees65453382be_es
beets76131442beets
begs75733832be_gs
bells76432162bells
bels66142492be_ls
belts75931162belts
bemas96424282bemas
bends85628972bends
benes75536232benes
bens65945702be_ns
benthos1238372benthos
bentos86218302bentos
bents76033692bents
bergs84718042bergs
berks115423122berks
berms95323662berms
berth104917882berth_
bertha11429172bertha
berthas12398762berthas
bes56557432be__s
beses75830722beses
bests75932612bests
bet58376672bet__
beta66234132bet_a
betel74419902betel
betels84515062betels
bethel1169642bethel
bethels1238532bethels
betise85616272betise
beton76022062beton
betons84919552betons
betta74916842betta
bettas84913922bettas
beys913829552be_ys
births115713602births
bites75641172bites
bits66148152bit_s
bitts75022592bitts
blahs105616512blahs
blets75324942blet_s
booths115313792booths
botas75328782botas
both96533432both_
bothy136713962bothy
bots66453952bot_s
botts75224862botts
breaths124411182breaths
briths115113862briths
broths115013922broths
butes714535872butes
buts67247692but_s
butts75824252butts
bytes105217492bytes
cetes75731102cetes
cheths14389822cheths
deaths105914442deaths
depths12428572depths
edhs86212102_edhs
etas46432272_etas
eth66630982_eth_
ethos85514192_ethos
fehs106522382fe_hs
fetas85624402fetas
fetes85630142fetes
fets75345942fet_s
fetus85816542fetus
getas65421482getas
gets55442482get_s
goths96513002goths
heaths126316382heaths
hehs106723962he_hs
heth107028022heth_
hets75547202het_s
jetes124922842jetes
jets115834102jet_s
kheths16495972kheths
kiths125814972kiths
laths86022402laths
lethe85717302lethe
lethes94818082lethes
lets47147942let_s
maths105624022maths
metes74736212metes
meth95827842meth_
metis75025902metis
moths106021552moths
myths135911602myths
nets45941532net_s
netts55320722netts
oaths86117312oaths
obeahs1135862obeahs
paths105521382paths
pechs125516202pechs
pehs95625762pe_hs
pets66248332pet_s
piths105817542piths
rets45352562ret_s
ruths85714642ruths
sets45549502set_s
setts55124322setts
soths86218622soths
techs106915832techs
tenths94412662tenths
teth76327882teth_
tets45847452tet_s
vets76835092vet_s
wets75940292wet_s
yeahs115214552yeahs
yechs136112582yechs
yetis85418392yetis
yetts86715132yetts
zetas145018162zetas
zibeths2142932zibeths

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.436409841.7
2DLD Change Limit538001443.29616322.8
3Display Results1441440.0632285.7
 (SQL Overall)1786911443.79547085.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.