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 “cables” 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
cables10452755(None) 
ables75935541_ables
cable95329911cable_
cabled114819871cabled
cabler104519171cabler
cablers114416711cablers
cablet104429461cablet
cablets114216341cablets
carles85435081carles
caules85927251caules
cobles104622881cobles
fables114921671fables
gables94222331gables
sables85026691sables
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
cabalas113516002cabalas
cabals104020152cabals
cabbed135416262cabbed
cabbies133115162cabbies
caber95126832cab_er
cabers105023922cabers
cabins104418922cabins
cabmen123610652cabmen
cabobs124311892cabobs
cabs86739422cab__s
caches137926912caches
cackles153717202cackles
cades85440732ca_des
cadges104716712cadges
cadres94017932cadres
cafes106426922ca_fes
cages85936012ca_ges
cajoles163712102cajoles
cakes116037672ca_kes
calces104420052calces
calesa8412472ca_lesa
calfs104919382ca_lfs
calks115421602ca_lks
callas84526752callas
called94126732called
callee84327292callee
callees94117782callees
caller85125482caller
callers94221962callers
callet84536762callet
callets93821702callets
calls75634732ca_lls
callus85317072callus
calms95222352ca_lms
calos74431902ca_los
calves115119282calves
calxes154113032calxes
camels105217082camels
cames97047312ca_mes
camlet104426582camlet
camlets114314622camlets
candles104422342candles
canes75350372ca_nes
canoes84725882canoes
cantles94721412cantles
capes95441922ca_pes
capless114312762capless
caplet104226812caplet
caplets114914522caplets
cares77369182ca_res
caries85147622caries
carle74535702carle_
carless95118492carless
carls77037422carl_s
carses85233652carses
cartes86239472cartes
carves115128452carves
cases75048382ca_ses
cashes114729882cashes
castes85631862castes
castles94917732castles
cates75951892ca_tes
caudles103912812caudles
caulds95512382caulds
caulis85320082caulis
caulks125611862caulks
cauls75727772caul_s
causes88026472causes
caves105639702ca_ves
cavies114525002cavies
chablis14368562chablis
chiles115425302chiles
chyles144813282chyles
cobbles133814822cobbles
coble94823172coble_
coles76055062c_oles
cradles103114132cradles
cubes95028162cub_es
cycles1339302cycles
dabbles124514772dabbles
dales66439742da_les
dalles74222062dalles
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
sabes76437462sab_es
sable74732162sable_
sabres85520862sabres
sales56055592sa_les
scabbles14167982scabbles
scabies11613332scabies
scales84529312sca_les
stables93219072stables
tabes76033922tab_es
tablas83716162tablas
table75429602table_
tabled94020042tabled
tablet84227642tablet
tablets94714382tablets
tales55451372ta_les
umbles103817492umbles
vales85434262va_les
vocables15145732vocables
wabbles144013992wabbles
wales86142832wa_les
wambles143714022wambles
warbles123215562warbles

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 Filter178691825510.326548131.9
2DLD Change Limit825511752.29635954.3
3Display Results1751750.0632777.8
 (SQL Overall)1786911752.68566551.6
 
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.