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 “prematurity” 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
prematurity185336(None) 
prematurely1852832prematurely
immaturity1752563_immaturity
maturity1367433___maturity
overmaturity2062273overmaturity
premature1347783prematur__e
prematures1447053prematur_es
prematurities1753003prematurities
armaturing1353964ar_maturing
aromaticity1875054aromaticity
creativity1845164cre_ativity
creaturely1552604cre_aturely
crematoria1455294crematori_a
crematories1546854crematories
crematorium17103494crematorium
crematory1647204cremator__y
dramaturgy1751484dramatur_gy
gratuity1244284gr__atu_ity
hematuria1445624_hematuri_a
hematurias1545004_hematurias
hematuric1645224_hematuri_c
peremptorily2161524peremptorily
perpetuity1753004perpetu_ity
pneumaticity2162434pneumaticity
preaudit1177024pre_a_udit_
preaudits1265024pre_a_udits
precatory1649114precator__y
predacity1745604preda__city
predatory1547704predator__y
prefatory1746684prefator__y
prelature1146264prelatur__e
prelatures1245724prelatur_es
premarital1455024prema__rital
premeasuring1752064premeasuring
preterit10315844pre__terit_
preterite11613204pre__terite
preterits11410964pre__terits
primality1687334prima__lity
primarily1644674prima__rily
primitivity2153004primitivity
relativity1645234_relativity
renaturing11176804_renaturing

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.440406115.9
2DLD Change Limit148819428.59317318.6
3Display Results42420.0301400.0
 (SQL Overall)178691429.06319716.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.