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 “trivet” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
trivet9372188(None) 
grivet103517821grivet
privet113821341privet
rivet85636361_rivet
trevet94818911trevet
trijet133916551trijet
trivets103911581trivets
brevet115717332brevet
civet105828732_civet
drive95318002drive_
drivel105110382drivel
driven105210142driven
driver104714492driver
drives105117112drives
grivets11357972grivets
privets122910052privets
revet84938842_revet
rive75537722_rive_
rived94825612_rived
riven85121622_riven
river85731692_river
rives85336002_rives
rivets94417112_rivets
strive95020962strive_
strived114713662strived
striven103910752striven
striver104315202striver
strives104119372strives
swivet123615472swivet
thrive125313222thrive_
thrived14458182thrived
thriven13447022thriven
thriver13479122thriver
thrives134611712thrives
toilet66228092toilet
trave85223032trave_
travel94112982travel
traves94222742traves
tret46653532tr__et
trevets10499972trevets
tribe74420272tribe_
tribes85119022tribes
trice75127492trice_
triced95518672triced
tricep103911072tricep
trices84826332trices
tricot8317752tricot
trident8314192trident
tried65026912tri_ed
trier54328532tri_er
tries55742812tri_es
trijets14308262trijets
trike95320162trike_
trikes105419492trikes
trimer85717152trimer
trine54734602trine_
trined74920712trined
trines64132562trines
trinket11314812trinket
triolet73219522triolet
tripe75425382tripe_
tripes85324872tripes
triplet94319212triplet
trippet113714112trippet
trisect939732trisect
triste63818642triste
trite54730032trite_
triter65120592triter
tritest7315272tritest
trivia938502trivia
trove85221922trove_
trover95014662trover
troves94719112troves

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551732.48333246.5
3Display Results73730.0332212.1
 (SQL Overall)178691732.87662131.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.