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

112 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
testicle103744(None) 
testicles1146771testicles
denticle1137772denticle
reticle94112622re_ticle
tentacle1037692tentacle
testable101412622testable
testily102910802testi_ly
textile1437222texti_le
vesicle12217922ves_icle
article9310923_article
bastile9313913basti_le
bastille1048003bastille
bernicle1245443bernicle
besmile1137463besmi_le
bestial9311643bestial_
canticle1239703canticle
centile94217183centi_le
cuticle1138233_cuticle
denticles1237753denticles
destine83719953desti_ne
entice81316863_entic_e
entitle7610293_entitle
fascicle1554633fascicle
fertile10311733ferti_le
festive1339773festi_ve
gentile83515293genti_le
gestic9312773gestic__
gestical1138993gestical
hecticly1843003hecticly
hostile10312553hosti_le
justice1637423justic_e
lenticel1066123lenticel
lenticule1144273lenticule
mastiche1547173mastiche
mistitle1038523mistitle
mysticly1843323mysticly
nestable101613673nestable
nestle63013953nest__le
obstacle1243593obstacle
ossicle944483_ossicle
ostiole739013_ostiole
particle1239533particle
pastiche1546933pastiche
pastille1038943pastille
pedicle1238973pe_dicle
pellicle1245043pellicle
pentacle1239383pentacle
pesthole1347553pesthole
pesticide1447283pesticide
pestle83215843pest__le
petiole9311303pe_tiole
postiche1547793postiche
reptile93914083repti_le
resile64627673res_i_le
restable101618443restable
restive10315933resti_ve
restyle1038763rest_yle
reticles103912483re_ticles
reticule1049303re_ticule
retile65929673re_ti_le
retitle73913093re_title
rusticly1345183rusticly
sectile9311973secti_le
sessile739523sessi_le
sestine73017923sesti_ne
sextile1438573sexti_le
stickle132410973__stickle
stifle93611903__stifle
stile54931573__sti_le
tactile9310613tacti_le
tastable101511973tastable
tastily103311643tasti_ly
teatime9310083teati_me
tectite9310583tecti_te
tektite1136883tekti_te
tenaille846813tenaille
tensible1037243tensible
tensile72612733tensi_le
tentacled1244953tentacled
tentacles1146713tentacles
tentie62521183tenti__e
terrible1046643terrible
tertial7313863tertial_
tertials8510073tertials
testacies1148373testacies
testacy1235963testac_y
testae64216253test__ae
testate73916233test_ate
testee64323303test__ee
testicular1254553testicular
testier74015643testi_er
testiest82715223testiest
testified1397843testified
testifier12116893testifier
testifies12139263testifies
testify13246943testi_fy
testing86021053testi_ng
testis64916713testi__s
textiles1536833texti_les
tortile7313193torti_le
trestle72611363trest__le
triticale1147513triticale
tunicle9308033t_unicle
vehicle15175253ve_hicle
ventricle1444383ventricle
vernicle1346433vernicle
versicle1366583versicle
vesicae12177703ves_icae
vesicles13127073ves_icles
vestibule1443693vestibule
vestige1137433vesti_ge
zestily19167563zesti_ly

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.436409841.7
2DLD Change Limit1461621127.40619735.6
3Display Results1121120.0502240.0
 (SQL Overall)1786911127.89222642.0
 
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.