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

68 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
trinketed1444251trinketed
trinketer1344561trinketer
trinketers1443731trinketers
trinkets1237141trinket_s
trinket11314812trinket__
trinketries15354312trinketries
trinketry1642802trinketry
triskeles1344272triskeles
briskets14346563brisket_s
cricketed1854683cricketed
cricketer1744563cricketer
cricketers1843893cricketers
crickets16418123cricket_s
crinites10612763crin_ites
crinkles14269163crink_les
drinkers13277823drinke_rs
flinkites1643483flinkites
friskets15326263frisket_s
pinkeyes17335973_pinkeyes
prickets16329083pricket_s
prinkers143010383prinke_rs
rickets134915093_ricket_s
thicketed1943613thicketed
thickets17287083thicket_s
thinkers15308703thinke_rs
ticketed15146643t_icketed
tickets134113683t_icket_s
tinkered1387683t_inkered
tinkerer1286803t_inkerer
tinkerers1395423t_inkerers
tinkers113517143t_inke_rs
tinkles113713923t_ink_les
trainees82712063train_e_es
tributes1047233tri_butes
trichites1448883trichites
trickeries1647143trickeries
trickers143812813tricke_rs
trickles143013763trick_les
trickster15265703trickster
tricksters16264763tricksters
trienes74118413tri__enes
trientes82812123tri_entes
trijets14308263tri_jet_s
trikes105419493tri_k__es
trimeter10310083tri_meter
trimeters1139213tri_meters
trindles93211683trin_dles
trines64132563trin___es
trinities9313343trinities
trinketing1544153trinketing
trinkums1443413trink_ums
triolets83410143triolet_s
triplets103510263triplet_s
triplexes1844253triplexes
triplites1148283triplites
trippets12357423trippet_s
triremes1035523tri_remes
trisceles1145293trisceles
trisemes1036643tri_semes
triskele1244573triskele_
trivets103911583tri_vet_s
truncates1145843truncates
twinjets1842413twinjet_s
twinkies1535983twink_ies
twinkles1535073twink_les
twinsets1133663twinset_s
urinates8314133urin_ates
wrinkles15296693wrink_les

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.440406115.9
2DLD Change Limit148641687.11020905.9
3Display Results68680.0302266.7
 (SQL Overall)178691687.58023574.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.