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

56 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
trinkums144341(None) 
crinums1135862crin_ums
dinkums1433672_dinkums
triduums1142612triduums
trinkets1237142trinkets
tritiums1056392tritiums
atriums939043atri__ums
brinks124616313brink__s
bunkums1544053_bunkums
craniums1297913craniums
crinkles14269163crinkles
crinum1039333crin_um_
dinkum1335893_dinkum_
drinkers13277823drinkers
drinks116810713drink__s
frenums1236203fren_ums
iridiums1144523iridiums
linkups1333633_linkups
linums838283_lin_ums
miniums113910223_miniums
prinkers143010383prinkers
prinks124315383prink__s
rinks94827103_rink__s
stickums1643943stickums
thinkers15308703thinkers
thinks134613363think__s
tinfuls1036593t_infuls
tinkers113517143t_inkers
tinkles113713923t_inkles
trainfuls1243953trainfuls
trangams1147203trangams
tranks104017763trank__s
transoms1048933transoms
trickers143812813trickers
trickles143013763trickles
tricks125319013trick__s
triduum1043413triduum_
trienniums1252253trienniums
trigrams11116353trigrams
trikes105419493tri_k_es
trilliums1144333trilliums
trims75021473tri___ms
trindles93211683trindles
trines64132563trin__es
trinket11314813trink_et
trismus935563trismu_s
triticums1343243triticums
tritium969013tritium_
trivium1256143trivium_
trunkfuls16112283trunkfuls
trunks10429753trunk__s
twinkies1535983twinkies
twinkles1535073twinkles
uraniums10117163uraniums
urinous7310083urinou_s
wrinkles15296693wrinkles

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.406440125.6
2DLD Change Limit146162566.93621073.0
3Display Results56560.0331697.0
 (SQL Overall)178691567.37524229.3
 
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.