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

178 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
sable7473216(None) 
able66340531_able
cable95329911cable
fable105824751fable
gable85325521gable
sabe66140571sab_e
sables85026691sables
sabre74821501sabre
sale44959701sa_le
stable83921641stable
suable83920551suable
table75429601table
usable84012551usable
abbe87627192_abbe
abele76323252_abele
abled86926832_abled
abler75624312_abler
ables75935542_ables
ably99725132_ably
abye97921002_abye
ale36572342_a_le
amble95924642amble
arable81821002arable
axle116424602_axle
babble94017112babble
babe86835822bab_e
babel95821692babel
bale66353842ba_le
bauble103813212bauble
bible95119422bible
cabled114819872cabled
cabler104519172cabler
cables104527552cables
cablet104429462cablet
carle74535702carle
coble94823172coble
dabble114515192dabble
dale55643982da_le
disable10516432disable
doable93115242doable
dyable12308982dyable
eagle64219482eagle
enable83318482enable
fabled124216382fabled
fabler116115812fabler
fables114921672fables
farle86929242farle
gabble113815722gabble
gabled105518452gabled
gables94222332gables
gale56347322ga_le
gamble115417182gamble
garble94118452garble
habile11515212habile
hale76052832ha_le
haole84820082haole
kale86533752ka_le
label75019382label
labile8315222labile
ladle66320442ladle
liable81415812liable
losable91910952losable
mabe85733362mab_e
macle96127002macle
maile75232222maile
male66052302ma_le
maple95521142maple
marble104219102marble
nabe66029492nab_e
noble74420992noble
padle84522342padle
pale66055012pa_le
parle75836162parle
posable112212782posable
rabble103818242rabble
rale45050562ra_le
ramble104519972ramble
roble75223022roble
ruble74521252ruble
sab56563202sab__
sabal75422482sabal
sabals84618862sabals
sabbed114518082sabbed
sabed86526812sabed
saber75330242saber
sabes76437462sabes
sabin74924952sabin
sabine84020392sabine
sabir75917002sabir
sabot7931782sabot
sabra75317852sabra
sabred95916532sabred
sabres85520862sabres
sabs66643742sab_s
saddle83915492saddle
sade55544472sa_de
sadhe94815132sadhe
sadly94519122sadly
sae38365182sa__e
safe75930952sa_fe
sage55044592sa_ge
saice75424052saice
sail45447162sail_
sailed74327762sailed
sailer63526102sailer
sails55738102sails
sake85244962sa_ke
sal36462882sa_l_
salable91415462salable
salep77022952sa_lep
sales56055592sa_les
sall44544682sa_ll
sallet63734542sallet
sally85129712sally
salp64534092sa_lp
sals46851672sa_ls
salt45758522sa_lt
salve85022132salve
same65245642sa_me
samlet84126562samlet
sample104215012sample
sane45954342sa_ne
saree55044662saree
sarge65531132sarge
sate45556102sa_te
sauce75121652sauce
saul45836522saul_
sauls55128122sauls
sault55834962sault
saute55028082saute
savable121711862savable
save75741362sa_ve
sayable121411612sayable
scabble13168652scabble
scale74629142scale
seeable91113942seeable
selle54428312selle
sewable121911172sewable
shale85332832shale
shamble14149262shamble
sidle65124032sidle
sizable1839892sizable
skiable1338882skiable
smile74823922smile
socle7419572socle
sole46053672s_ole
sowable121610752sowable
spale74929212spale
spile75230082spile
stabile9312062stabile
stabled103514952stabled
stabler94014932stabler
stables93219072stables
stably113314122stably
stale55637102stale
staple84415822staple
stele55026842stele
stile54931572stile
stole54928812stole
style85519362style
suably112814532suably
sublet82827242sublet
subtle82113432subtle
swale85221592swale
tabla73318362tabla
tabled94020042tabled
tables84524892tables
tablet84227642tablet
tale46154162ta_le
unable83819222unable
usably11288982usably
useable9911062useable
vale74937342va_le
viable111613772viable
wabble133714842wabble
wale74546432wa_le
wamble134415752wamble
warble113516602warble

Search took 3 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.326548131.9
2DLD Change Limit538001781.75030742.9
3Display Results1781780.0632825.4
 (SQL Overall)1786911782.13983539.5
 
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.