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

88 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
postdates124886(None) 
postdate1139651postdate_
postdated1346881postdated
apostates1149162apost_ates
outdates93114742_outdates
postages112815322post_ages
postfaces1656272postfaces
posthastes1546272posthastes
postulates1268962postulates
prostates11314422prost_ates
prostrates12411992prostrates
apostate1049853apost_ate_
apostolates1354193apostolates
castrates11312673castrates
costate94019273cost_ate_
estates74520183_est_ates
foredates13310053foredates
gestates93213733gest_ates
hostages122311693host_ages
instates81615833inst_ates
iodates8312903io__dates
lustrates939463lustrates
misdates111113633mis_dates
notates72817483no_t_ates
ostomates1149343_ostomates
outdares92712463_outdares
outdate83016423_outdate_
outdated1012513193_outdated
outrates82421373_outrates
oxidates1636333_oxidates
pastorates12410143pastorates
pectates122213953pect_ates
phosphates2087163phosphates
playdates1554903playdates
podites103014733po__dites
populates132710673populates
portages112613223port_ages
posadas1037193posada__s
postage103214853post_age_
postals93716373post_a_ls
postbags1345293postba_gs
postbase1246443postbase_
postboxes2045243postboxes
postcards1445733postcards
postcavas1653523postcavas
postcodes1446153postcodes
postdating1447163postdating
postdebate1552753postdebate_
postdive1445763postdive_
postdocs1345273postd_ocs
postface1566123postface_
postfixes2164473postfixes
postgame1345523postgame_
posthaste1456603posthaste_
postheats1447433postheat_s
postholes14410453postholes
postiches1648223postiches
posties93128813post__ies
postiques2045833postiques
postludes1244623postludes
postmarks1744753postmarks
postmaster14115713postmaster
postmasters15115323postmasters
postnatal1144463postnatal
postpones1348833postpones
postposes1348193postposes
postrace12310533postrace_
posttest10410233post__test
postulate1169813postulate_
postulated1377653postulated
postures10313783post_ures
potages102416423po_t_ages
potatoes1039943po_t_atoes
pottages112910453po_ttages
poundages1344153poundages
predates11615813p_redates
prostate10314533prost_ate_
prostrate11412483prostrate_
prostrated1349423prostrated
pustulates1276213pustulates
restates83423433rest_ates
rostrate8313843rostrate_
rotates72819773ro_t_ates
sedates83418033__sedates
states64337083__st_ates
testates83615453test_ates
unstates81314993unst_ates
upstates10189643upst_ates

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641887.18620684.8
3Display Results88880.0461913.0
 (SQL Overall)178691887.38824186.7
 
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.