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

71 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
travesty144448(None) 
bravest124211752bravest_
gravest114011632gravest_
traves94222742traves__
bravely15428233brave_ly
bravery15428133brave_ry
braves115524083braves__
brawest123810483brawest_
cravenly1644663cravenly
craves115825393craves__
gravelly15385773gravelly
gravely14469063grave_ly
graves104624003graves__
gravesite1344443gravesite
gravity1437183grav_ity
grayest11489363grayest_
harvest132112753harvest_
harvests14246173harvests
iratest7312483iratest_
majesty1943503_majesty
rarest65725483_rarest_
ravelly13268353_ravelly
raves85441973_raves__
rawest93615063_rawest_
revest94623603_revest_
revests104413733_revests
suavest10310623suavest_
tamest85721293t_amest_
tapestry1343833t_apestry
tartest72517533tartest_
tasty84820313t_a__sty
testy85419063t___esty
thraves13469713thraves__
toasty9509563toa__sty
trabeate1049483trabeate
tracery12399793trace_ry
traces85329933traces__
trades75724503trades__
tragedy1234793trage_dy
traject1637043traject_
trajects1744533trajects
trapes85024463trapes__
trapesed1136473trapesed
trapeses1039153trapeses
trapnest10310923trapnest_
trapnests1144433trapnests
trashy12509053tra__shy
trave85223033trave___
travel94112983trave__l
traveled12349453traveled
traveler11328433traveler
travelog1243513travelog
travels104711293trave_ls
traversal1243833traversal
traverse1136213traverse
traversed1344563traversed
traverser1244143traverser
traverses1246343traverses
travestied1443833travestied
travesties1345423travesties
travestying1851933travestying
treaty94414353tr__eaty
tressy9448553tr__essy
trevet94818913treve_t_
trevets10499973treve_ts
tritest7315273tritest_
trivet93721883trive_t_
trivets103911583trive_ts
troves94719113troves__
truest64816193tr_uest_
trusty94710113tr__usty

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 Limit146162716.81321453.4
3Display Results71710.0135461.5
 (SQL Overall)178691717.26224606.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.