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

96 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
testicles114677(None) 
testicle1037441testicle_
denticles1237752denticles
reticles103912482re_ticles
tentacles1146712tentacles
testacies1148372testacies
testifies12139262testifies
textiles1536832texti_les
vesicles13127072ves_icles
articles10310243_articles
bastiles10313353basti_les
bastilles1147363bastilles
bernicles1345403bernicles
besmiles1237393besmi_les
canticles1339183canticles
centiles103615813centi_les
cuticles1237893_cuticles
denticle1137773denticle_
destines93619663desti_nes
destinies10410843destinies
entices91616333_entic_es
entitles8710663_entitles
fascicles1664263fascicles
fetiales11319613fe_tiales
fetiches1636953fe_tiches
gentiles93713523genti_les
hostiles11312213hosti_les
justices1737523justic_es
lenticels1184493lenticels
lenticules1244413lenticules
mastiches1647333mastiches
mestinoes1157313mestinoes
mestizoes2064173mestizoes
mistitles1147953mistitles
nestles73015463nest__les
obstacles1343713obstacles
ossicles1054183_ossicles
ostioles839273_ostioles
particles1339803particles
pastiches1637453pastiches
pastilles1148703pastilles
pedicles1338683pe_dicles
pellicles1344923pellicles
pentacles1338773pentacles
pestholes1448233pestholes
pesticides1546723pesticides
pestles93217693pest__les
petioles10311643pe_tioles
postiches1648223postiches
reptiles103913063repti_les
resiles74026543res_i_les
restables111511423restables
restitches1545063restitches
restyles1139193rest_yles
reticle94112623re_ticle_
reticules1139013re_ticules
retiles74426993re_ti_les
retitles83612593re_titles
sestines82717243sesti_nes
sextiles1537643sexti_les
stickles142512103__stickles
stifles103013393__stifles
stiles64328773__sti_les
teatimes1039443teati_mes
tectites1039993tecti_tes
tectrices1346253tectric_es
tektites1236613tekti_tes
tenailles946323tenailles
tentacle1037693tentacle_
tentacled1244953tentacled
tertials8510073tertial_s
testable101412623testable_
testates83615453test_ates
testees74215913test__ees
testes65125823test___es
testicular1254553testicular
testier74015643testi__er
testiest82715223testi__est
testified1397843testified
testifier12116893testifier
testifiers13124503testifiers
testily102910803testi_l_y
testiness9209753testiness
testis64916713testi___s
textile1437223texti_le_
trestles83012553trest__les
triticales1246263triticales
tunicles10217133t_unicles
vehicles16204683ve_hicles
ventricles1544523ventricles
vernicles1446133vernicles
versicles1446353versicles
vertices13612283vertic_es
vesicle12217923ves_icle_
vestibules1543603vestibules
vestiges1238243vesti_ges

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 Filter1786911486410.403443402.0
2DLD Change Limit148641967.03321134.8
3Display Results96960.0462087.0
 (SQL Overall)178691967.48223882.8
 
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.