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

48 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
paramenta136886(None) 
parament12415391parament_
paraments13511551paraments
paramatta1345312paramatta
paramecia1545932paramecia
ramenta9311182__ramenta
sarmenta1047722sar_menta
apartment1347033apartment_
apartmental1552833apartmental
apartments1445703apartments
argumenta1244583_argumenta
armament1249633_armament_
armaments1347473_armaments
catamenia1344413catamenia
garment10315233gar_ment_
garments1139973gar_ments
maranta9311693mara__nta
parakeet14410523parakeet_
parakeets1545103parakeets
paramattas1454363paramattas
paramedic1645723paramedic
parameter1349123parameter
paramnesia1454503paramnesia
paramount1347183paramount_
paramounts1443893paramounts
parapet11317643parape_t_
parapets1239763parape_ts
parchment1846913parchment_
parchments1944983parchments
parent83230423par__ent_
parental10310943par__ental
parents93418123par__ents
parliament1454653parliament_
parliaments1553573parliaments
pavement1549443pavement_
pavements1647003pavements
payment14310703pa_yment_
payments1536943pa_yments
placenta1275723p_lacenta
portamenti1454203portamenti
portamento1463793portamento
sacrament1347943sacrament_
sacramental1553523sacramental
sacraments1445853sacraments
sarment9318763sar_ment_
sarments10311963sar_ments
varment12313243var_ment_
varments1339063var_ments

Search took 7 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.436409841.7
2DLD Change Limit148641486.50022867.8
3Display Results48480.0163000.0
 (SQL Overall)178691486.95225703.5
 
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.