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

175 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
sables8502669(None) 
ables75935541_ables
cables104527551cables
fables114921671fables
gables94222331gables
sabes76437461sab_es
sable74732161sable_
sabres85520861sabres
sales56055591sa_les
stables93219071stables
tables84524891tables
abbes96723522_abbes
abeles84719392_abeles
able66340532_able_
abled86926832_abled
abler75624312_abler
ablest84721832_ablest
abyes105518532_abyes
ales47067102_a_les
ambles105121862ambles
arables91814972arables
arles56735742_arles
axles125219472_axles
babbles104416322babbles
babels105216722babels
babes95834112bab_es
babies106123652babies
bales76250082ba_les
baubles113611862baubles
bibles104617642bibles
cable95329912cable_
cabled114819872cabled
cabler104519172cabler
cablers114416712cablers
cablet104429462cablet
cablets114216342cablets
carles85435082carles
caules85927252caules
cobles104622882cobles
dabbles124514772dabbles
dales66439742da_les
dalles74222062dalles
disables11410902disables
eagles73819162eagles
enables92813122enables
fable105824752fable_
fabled124216382fabled
fabler116115812fabler
fablers124812612fablers
farles96025782farles
gabbles124415412gabbles
gabies93820732gabies
gable85325522gable_
gabled105518452gabled
gales65442482ga_les
gambles124016202gambles
garbles104016922garbles
hales85449842ha_les
haoles94919802haoles
kales95730982ka_les
kayles134712002kayles
labels84515682labels
ladles74619542ladles
mabes96331532mab_es
macles107023222macles
mailes84329112mailes
males75049792ma_les
maples104819422maples
marbles114516652marbles
nabes75427092nab_es
nobles83319722nobles
padles95221122padles
pales75753802pa_les
parles86334402parles
rabbles113517972rabbles
rabies85226022rabies
rales54947492ra_les
rambles113118312rambles
robles85321692robles
rubles83921702rubles
sabals84618862sabals
sabbed114518082sabbed
sabe66140572sab_e_
sabed86526812sab_ed
saber75330242sab_er
sabers85224732sabers
sabines94318482sabines
sabins85521982sabins
sabirs85414632sabirs
sabots8314702sabots
sabras85116362sabras
sabre74821502sabre_
sabred95916532sabred
sabs66643742sab__s
saddles95415742saddles
sades65239892sa_des
sadhes104715372sadhes
safes85226722sa_fes
sages65339062sa_ges
saices84221802saices
sailed74327762sailed
sailer63526102sailer
sailers73822322sailers
sails55738102sail_s
sakes95540752sa_kes
sale44959702sa_le_
salep77022952sa_lep
saleps85014902sa_leps
sallet63734542sallet
sallets73719652sallets
sallies73227812sallies
salps74423242sa_lps
sals46851672sa_l_s
salts55431882sa_lts
salves94221762salves
samlet84126562samlet
samlets93813552samlets
samples112815452samples
sanes55649072sa_nes
sanies63031952sanies
sapless93313442sapless
sarees65329942sarees
sarges75128592sarges
sashes94728482sashes
sasses64124392sasses
sates54949322sa_tes
sauces84919502sauces
sauls55128122saul_s
saults65816172saults
sautes63924912sautes
saves85838632sa_ves
saxes125229342sa_xes
scabbles14167982scabbles
scabies11613332scabies
scales84529312scales
selles64426982selles
shales94731252shales
shambles15159042shambles
sidles74721152sidles
smiles84522292smiles
socles8418452socles
soles55547922s_oles
spales84728102spales
spiles84227912spiles
stabiles10311402stabiles
stable83921642stable_
stabled103514952stabled
stabler94014932stabler
stablers103611152stablers
stablest103312942stablest
stales65538292stales
staples93617212staples
steles63725662steles
stiles64328772stiles
stoles63927672stoles
styles94418652styles
suable83920552suable_
sublet82827242sublet
sublets92616702sublets
swales93920762swales
syboes1139342syboes
tabes76033922tab_es
tablas83716162tablas
table75429602table_
tabled94020042tabled
tablet84227642tablet
tablets94714382tablets
tales55451372ta_les
umbles103817492umbles
usable84012552usable_
vales85434262va_les
wabbles144013992wabbles
wales86142832wa_les
wambles143714022wambles
warbles123215562warbles

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 Filter178691825510.343520965.0
2DLD Change Limit825511752.65631080.9
3Display Results1751750.0463804.3
 (SQL Overall)1786911753.04558683.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.