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 “vocables” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
vocables1514573(None) 
vocable14189671vocable_
cables104527552__cables
evocable1537102evocable_
locales93715092loca_les
movables15175572movables
notables10178242notables
potables12179702potables
sociables1344962sociables
vocably17157152vocabl_y
vocabs13336312vocab__s
vocalese13165502voca_lese
vocals113811582voca_l_s
votable122111372votable_
ables75935543___ables
arables91814973_arables
avocadoes1562343avocadoes
avowable1635453avowable_
bobbles104514913bo_bbles
cable95329913__cable_
cabled114819873__cabled
cabler104519173__cabler
cablers114416713__cablers
cablet104429463__cablet
cablets114216343__cablets
carles85435083__carles
cascables15165773cascables
caules85927253__caules
cobbles133814823co_bbles
cobles104622883__cobles
cocaines121314443cocaines
cockles153414643coc_kles
codable12311663codable_
coracles121811163coracles
disables11410903disables
doable93115243do_able_
doubles103113353do_ubles
dowable13189453dowable_
durables11237013durables
eatables10169793eatables
educables1443473educables
enables92813123_enables
fables114921673__fables
foibles1238853fo_ibles
gables94222333__gables
gobbles123512583go_bbles
hobbles143313783ho_bbles
jacales16310323jaca_les
locale83915653loca_le_
locals83714503loca_l_s
locates93218813loca_tes
lockable1636953lockable_
locules92812603loc_ules
losable91910953losable_
lovable12179553lovable_
mockable1846643mockable_
morales93619403mora_les
movable14189433movable_
moveables16163963moveables
nobbles114014523no_bbles
nobles83319723no__bles
noctules1036583noctules
nombles113212343no_mbles
nopales93812523nopa_les
notable92114903notable_
oracles93212423_oracles
parables121613563parables
payables15166483payables
pokable15209503pokable_
portables1337873portables
posable112212783posable_
potable112115363potable_
probables1545433probables
ratables10159723ratables
retables101712673retables
revocable1647003revocable_
robles85321693ro__bles
rocailles1144993rocailles
rocamboles1652303rocamboles
rockabies1744223rockabies
rockable1638013rockable_
rockabyes2042493rockabyes
ropable111611333ropable_
roubles93413513ro_ubles
rowable121510303rowable_
sables85026693__sables
scabbles14167983_scabbles
scabies11613333_scabies
scales84529313_sca_les
socages101012053soca_ges
sociable1239503sociable_
socles8418453soc__les
solubles1065893solubles
sowable121610753sowable_
stables93219073_stables
storables1146283storables
tables84524893__tables
taxables1734383taxables
totable92313363totable_
towable121910113towable_
vacates12312833vaca_tes
vacuoles1345013vacuoles
vales85434263v__a_les
valuables1442973valuables
variables1444673variables
vendables15165153vendables
viable111613773v_iable_
violable1337543violable_
vocab12409973vocab___
vocabular1652163vocabular
vocal104715643voca_l__
vocaleses14145323vocaleses
vocalic1446943voca_lic
vocalics1545593vocalics
vocalise131510813voca_lise
vocalises141710333vocalises
vocalism15159043voca_lism
vocalist131512123voca_list
vocalizes231610103vocalizes
vocally15188343voca_lly
vocalness1444393vocalness
vocatives1745883vocatives
voces105918053voc___es
voidable1466853voidable_
voiles94616443vo__iles
volatiles1246133volatiles
volcanoes1443783volcanoes
voles86234043vo___les
voluble1244503voluble_
votaries11312013votaries
voteable1347213voteable_
voyages1435703voya_ges
wobbles143412433wo_bbles
zocalos1835393zoca_los

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621347.22020244.0
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.70323197.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.