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

65 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
postdated134688(None) 
postdate1139651postdate_
postdates1248861postdates
outdated1012513192_outdated
postulated1377652postulated
prostrated1349422prostrated
apostate1049853apost_ate_
apostates1149163apost_ates
castrated1239513castrated
costate94019273cost_ate_
estated83715573_est_ated
foredated1447683foredated
gestated102910573gest_ated
instated91613343inst_ated
iodated9310023io__dated
lustrated1037963lustrated
misdated121211123mis_dated
notated82713663no_t_ated
outdared102711513_outdared
outdate83016423_outdate_
outdates93114743_outdates
outrated92219313_outrated
oxidated1745033_oxidated
populated14228803populated
portaged12228463port_aged
portaled11239203port_aled
portrayed1564103portrayed
posited10511493pos__ited
postage103214853post_age_
postages112815323post_ages
postbase1246443postbase_
postcard1346523postca_rd
postdating1447163postdating
postdebate1552753postdebate_
postdive1445763postdive_
posted93722493pos___ted
postface1566123postface_
postfaces1656273postfaces
postfixed2263173postfixed
postgame1345523postgame_
posthaste1456603posthaste_
posthastes1546273posthastes
postmarked1943193postmarked
postmaster14115713postmaster
postnatal1144463postnatal
postpaid1376543postpa_id
postponed1445903postponed
postposed1445303postposed
postrace12310543postrace_
postulate1169813postulate_
postulates1268963postulates
postured1139493post_ured
potted94624013po_t__ted
predated12513273p_redated
prostate10314533prost_ate_
prostates11314423prost_ates
prostrate11412483prostrate_
prostrates12411993prostrates
pustulated1375543pustulated
restated93120183rest_ated
rostrate8313843rostrate_
rotated82715293ro_t_ated
sedated93714353__sedated
stated75427833__st_ated
unstated91615813unst_ated

Search took 9 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.423422437.4
2DLD Change Limit148641657.53019739.8
3Display Results65650.0331969.7
 (SQL Overall)178691657.98622375.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.