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

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

42 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
dramaturges156170(None) 
dramaturge1451781dramaturge_
dramaturgies1671331dramaturgies
dramaturg1352262dramaturg__
dramaturgic1751452dramaturgic
dramaturgy1751482dramaturg_y
armatures1166973ar_matur_es
dramatises1356763dramat_ises
dramatizes2247353dramat_izes
prematures1447053prematur_es
thaumaturges1861253thaumaturges
arcatures1186834ar_catur_es
armature10106964ar_matur_e_
armatured1264614ar_matur_ed
creatures1138414cr_eatur_es
crematories1546854crematories
crenatures1245334crenatur_es
damages11511274d_ama___ges
defeatures1444004defeatur_es
demiurges1343864d_em_iurges
denatures1038124d_enatur_es
dramadies1344804drama__dies
dramatics1466914dramat__ics
dramatise1247314dramat_ise_
dramatised1454884dramat_ised
dramatists1365714dramat_ists
dramatize2147894dramat_ize_
dramatized2346524dramat_ized
dramaturgical1961144dramaturgical
drawtubes1541644dra_wtu_bes
drayages1344504draya___ges
fractures14147234fra_ctur_es
gramaries12128304grama__ries
gramaryes1572874grama__ryes
immatures1344324_immatur_es
matures9314304___matur_es
prelatures1245724prelatur_es
premature1347784prematur_e_
raptures1037574_ra_ptur_es
renatures939444_renatur_es
thaumaturge1761254thaumaturge_
thaumaturgies1961014thaumaturgies

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit148819429.45615738.0
3Display Results42420.0301400.0
 (SQL Overall)178691429.92218009.6
 
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.