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

135 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
fables11492167(None) 
ables75935541_ables
cables104527551cables
fable105824751fable_
fabled124216381fabled
fabler116115811fabler
fablers124812611fablers
farles96025781farles
gables94222331gables
sables85026691sables
tables84524891tables
abbes96723522_abbes
abeles84719392_abeles
able66340532_able_
abled86926832_abled
abler75624312_abler
ablest84721832_ablest
abyes105518532_abyes
ales47067102_a_les
ambles105121862ambles
arables91814982arables
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
eagles73819162eagles
enables92813122enables
fabber134814112fabber
fabbest1438032fabbest
fabs98635862fab__s
faces106439432fa_ces
facies113921592facies
fades94932862fa_des
fadges114814032fadges
faeces114713122faeces
failed105421602failed
failles102914132failles
fails85631482fail_s
fakes126032482fa_kes
falces115216002falces
fallen93813372fallen
faller94621232faller
fallers103917992fallers
falls85727652fa_lls
false84818122fa_lse
fames105735922fa_mes
fanes84639892fa_nes
farces115223322farces
fares85852872fa_res
farle86929242farle_
farls85731112farl_s
fasces114914542fasces
fashes124524022fashes
fates85139232fa_tes
fatless103212202fatless
fauces114916152fauces
faulds10438962faulds
faults94513552faults
fauves125610422fauves
faves115331422fa_ves
faxes155726652fa_xes
fazes175527212fa_zes
fibres114312122fibres
files85441272f_iles
filles94224522filles
fimbles143510662fimbles
foibles1238852foibles
folles93820472folles
fugles104715782fugles
fumbles143514412fumbles
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
parles86334412parles
rabbles113517972rabbles
rabies85226022rabies
rales54947492ra_les
rambles113118312rambles
robles85321692robles
rubles83921702rubles
sabes76437462sab_es
sable74732162sable_
sabres85520862sabres
sales56055592sa_les
stables93219072stables
tabes76033922tab_es
tablas83716162tablas
table75429602table_
tabled94020042tabled
tablet84227642tablet
tablets94714382tablets
tales55451372ta_les
umbles103817492umbles
vales85434262va_les
wabbles144013992wabbles
wales86142842wa_les
wambles143714022wambles
warbles123215562warbles

Search took 6 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.750238254.7
2DLD Change Limit825511354.58018024.2
3Display Results1351350.0462934.8
 (SQL Overall)1786911355.37633238.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.