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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
vernacle134558(None) 
vernacles1445071vernacles
vernicle1346431vernicle
barnacle1245942barnacle
bernicle1245442bernicle
cenacle1139122ce_nacle
vernal93514212verna_l_
vernally1447822vernally
vernicles1446132vernicles
versicle1366582versicle
averrable14105413averrable
avertable14117343avertable
barnacled1444003barnacled
barnacles1355333barnacles
berdache1644033berdache
bernicles1345403bernicles
binnacle12325633binnacle
burnable1237263burnable
cenacles1238023ce_nacles
coracle112011723cor_acle
cornicle1258783cornicle
debacle1237443de_bacle
enable83318483_e_nable
errable9312183_errable
fenagle11197153fe_nagle
furnace1235943furnac_e
governable1643633governable
learnable1145563learnable
manacle11310283_manacle
menace103216943me_nac_e
miracle1138843mir_acle
oracle84313293_or_acle
overable13513573over_able
overfacile1844913overfacile
overnice13310093overnic_e
oversale11313873oversa_le
overscale1447993overscale
pentacle1239383pentacle
percale11314093perca_le
pinnacle12416963pinnacle
servable13310093servable
tabernacle1452053tabernacle
tenable93214493te_nable
tenace82715693te_nac_e
tentacle1037693tentacle
ternate7415483terna_te
terrace93311843terrac_e
treacle939973_treacle
turnable1037853turnable
variable13310063variable
vehicle15175253ve_hicle
veinal93812963veina_l_
veinule1056243vein_ule
venae85920983ve_na__e
venal85523213ve_na_l_
venally13119563ve_nally
vendable14159693vendable
vendace1357363vendac_e
venule94411763ve_n_ule
verbal112513663verba_l_
verbally1647183verbally
verbals121910743verba_ls
verbile1249863ver_bile
veritable1448743veritable
vernacular15133693vernacular
vernalize2159843vernalize
verrucae1343193verrucae
versal93013753versa_l_
versatile1245163versatile
versicles1446353versicles
vesicle12217923ve_sicle

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 Limit146162716.58022213.1
3Display Results71710.0164437.5
 (SQL Overall)178691717.01625469.1
 
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.