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

158 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
abets7562167(None) 
abet610547941abet_
abuts75417071abuts
bets67051441_bets
abas68642082ab_as
abate76627842abate
abates85825032abates
abatis84317932abatis
abbas95918642abbas
abbes96723522abbes
abbess10509772abbess
abbeys13538422abbeys
abbots1039282abbots
abeam9316532abeam
abed79734132abe_d
abele76323252abele
abeles84719392abeles
ables75935542ables
ablest84721832ablest
aborts84916182aborts
abos67734412ab_os
abris75722602abris
abs59356072ab__s
absents93510722absents
abut66834952abut_
abyes105518532abyes
abys97221882ab_ys
abyss10669462abyss
aces67645092ace_s
aceta74017352aceta
acts66929862a_cts
adepts9117102adepts
adits66523712adits
agents74816292agents
agers65027852agers
ages55844592age_s
aglets73915682aglets
airts55626342airts
aits46355532a_its
akees96119242akees
alecs76620732alecs
alefs87319662alefs
alerts64418222alerts
ales47067102ale_s
alts46639902a_lts
ambers104519582ambers
ambits103713412ambits
amens75624842amens
aments85219802aments
anes45255932ane_s
antes56334322antes
ants47243472a_nts
apers76629132apers
apes66047432ape_s
areas55935772areas
ares45871022are_s
arete56031352arete
aretes64425352aretes
armets84918352armets
arts49650262a_rts
assets65617662assets
ates45047922ate_s
aunts55227632aunts
avens86419332avens
avers85127312avers
averts95715242averts
aves76142602ave_s
awes76037552awe_s
axels126313632axels
axes117337852axe_s
ayes76543512aye_s
babels105216722babels
babes95834112babe_s
bahts105617802bahts
baits76630582baits
barbets114915842barbets
basts75936932basts
bates75846342bates
bats66962332_bats
batts76727562batts
beats76042242_beats
beds75937782_beds
bees65453382_bees
beets76131442beets
begs75733832_begs
bels66142492_bels
belts75931162_belts
bens65945702_bens
bents76033692_bents
bes56557432_be_s
best66355322_best
bests75932612_bests
bet58376672_bet_
beta66234132_beta
betas75528762_betas
beth96629232_beth
beths105519222_beths
beys913829552_beys
bits66148162_bits
blets75324942blets
bots66453952_bots
buts67247692_buts
cabers105023922cabers
cablets114216342cablets
cadets96316512cadets
carets85330772carets
debts86418372debts
deets65330242deets
diets66026642diets
duets65323882duets
ebbets10376832ebbets
facets116316652facets
fets75345942_fets
frets85523402frets
gets55442482_gets
habits113014652habits
haets86525122haets
hets75547202_hets
jabots1538882jabots
jets115834102_jets
keets95123482keets
khets124913432khets
labels84515682labels
labrets939362labrets
leets54927122leets
lets47147942_lets
mabes96331532mabe_s
meets74224612meets
nabes75427092nabe_s
nets45941532_nets
obes66036832obe_s
obeys107010642obeys
obits74617552obits
objets15125322objets
palets85122312palets
pets66248332_pets
poets76024442poets
rabats83116222rabats
rabbets11279422rabbets
ramets83517392ramets
rets45352562_rets
sabers85224732sabers
sabes76437462sabe_s
sabots8314702sabots
sets45549502_sets
stets55423912stets
suets55126102suets
tabers84621572tabers
tabes76033922tabe_s
tablets94714382tablets
tets45847462_tets
trets55928022trets
valets93715622valets
vets76835092_vets
weets85427722weets
wets75940292_wets
whets115019612whets
zibets1737742zibets

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 Limit538001581.62633087.3
3Display Results1581580.0463434.8
 (SQL Overall)1786911581.765101241.4
 
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.