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

110 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
denticles123775(None) 
denticle1137771denticle_
canticles1339182canticles
centiles103615812centi_les
dentiled1039742denti_led
dentils84115582denti_l_s
dentines93418402denti_nes
entices91616332_entic_es
entitles8710662_entitles
gentiles93713522genti_les
lenticels1184492lenticels
lenticules1244412lenticules
pentacles1338772pentacles
reticles103912482re_ticles
tentacles1146712tentacles
testicles1146772testicles
ventricles1544522ventricles
articles10310253_articles
bernicles1345403bernicles
canticle1239703canticle_
cenacles1238023cen_acles
centiares1167653centiares
centile94217183centi_le_
centimes124012613centi_mes
centrioles1245803centrioles
centuples13134333centuples
cuticles1237893_cuticles
debacles1335723de_bacles
deciles104417723de_ci_les
defiles114016843de_fi_les
deices94119373de__ic_es
deities82621923deiti__es
denials84114133den_ial_s
denies74729643den_i__es
densifies1347993densifies
densities10310793densities
dentals83915393dent_al_s
dentil74017883denti_l__
dentine83320243denti_ne_
dentins83419223denti__ns
dentists939263denti_sts
dentures9312453dent_ures
destines93619663desti_nes
destinies10410843destinies
detaches1439653de_taches
deticked1635693de_ticked
deticker1545283de_ticker
detickers1634423de_tickers
deticks1437353de_tic_ks
detinues9569823de_tinues
devices133212583de_vic_es
devoices14307413devoic_es
disentitles1255263disentitles
encircles1343923_encircles
enisles72312603_en_isles
enriches1337263_enriches
ensiles72714833_ensi_les
entice81316863_entic_e_
enticed101411193_entic_ed
enticer91510423_entic_er
enticers10139093_enticers
entires71517783_enti_res
entities8617413_entities
entitle7610293_entitle_
entitled967503_entitled
fencibles1644093fencibles
fetiales11319613fe_tiales
fetiches1636953fe_tiches
funicles13246833fun_icles
gentile83515293genti_le_
gentles83714343gent__les
gentrices1258923gentric_es
identifies1445803identifies
identities1146953identities
intitles8710003_intitles
lenticel1066123lentic_el
lenticule1144273lenticule_
lentils73912973lenti_l_s
monticules1444793monticules
panicles121010123pan_icles
pantiles103617163panti_les
particles1339813particles
pedicles1338683pe_dicles
pellicles1344933pellicles
pentacle1239383pentacle_
petioles10311643pe_tioles
prentices131111903prentic_es
reptiles103913073repti_les
reticle94112623re_ticle_
reticules1139013re_ticules
retiles74426993re_ti_les
retitles83612593re_titles
sanicles10149943san_icles
seniles72618023sen_i_les
sensibles1145953sensibles
sentinels947423sentinels
sextiles1537643sexti_les
tenailles946323tenailles
tentacle1037693tentacle_
tentacled1244953tentacled
testicle1037443testicle_
textiles1536833texti_les
tunicles10217133tun_icles
vehicles16204683ve_hicles
vendibles15164583vendibles
ventricle1444383ventricle_
vernicles1446133vernicles
versicles1446353versicles
vertices13612283vertic_es
vesicles13127073ve_sicles

Search took 9 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411108.21618091.7
3Display Results1101100.0502200.0
 (SQL Overall)1786911108.68920565.2
 
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.