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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
postrace1231054(None) 
postface1566121postface
footrace1346412footrace
mistrace12312642mistrace
ostraca937822_ostraca
outrace92418552_outrace
postage103214852post_age
postbase1246442postbase
postdate1139652postdate
postfaces1656272postfaces
postgame1345522postgame
prostrate11412482prostrate
rostrate8313842rostrate
abstract1249223abstract
apostacy1544283apost_acy
apostate1049853apost_ate
bootlace1245403bootlace
castrate10313863castrate
coatrack1645853coatrack
contract122915633contract
costae85319683cost_a_e
costate94019273cost_ate
disgrace1248283disgrace
distract11313023distract
footpace1544493footpace
footraces1446713footraces
fosterage1344663fosterage
horserace1445733horserace
hostage113111233host_age
lustrate8310443lustrate
mistraced1439453mistraced
mistraces13312293mistraces
monstrance1445233monstrance
ostracise1146293_ostracise
ostracize2045173_ostracize
ostracod1144873_ostracod
ostracode1243873_ostracode
ostracon1045263_ostracon
ostraka1144833_ostraka
ostrich1238663_ostrich
outface123011973_outface
outpace112613023_outpace
outraced112414203_outraced
outraces102217863_outraces
outrage82616893_outrage
outrance102212783_outrance
outrate72323183_outrate
outrave102614413_outrave
pastorale1147323pastorale
pastorate11411183pastorate
pastrami1246333pastrami
pasturage1244923pasturage
petrale9312623p_etrale
pistache1545893pist_ache
pomace123111913po__mace
populace14256253populace
portage103013643port_age
portance12310123portance
porterage1245763porterage
portrait10510323portrait
portray1237483portra_y
portrayed1564103portrayed
portrayer1464003portrayer
portrays1345293portrays
postages112815323post_ages
postal84317533post_a_l
postals93716383post_als
postbag1245223postba_g
postbags1345293postbags
postcard1346523postcard
postcava15134033postcava
postcavae1653033postcavae
postcode1346323postcode
postcrash1643493postcrash
postdated1346883postdated
postdates1248863postdates
postdive1445763postdive
postdoc1245263postdoc_
postdocs1345273postdocs
postfire1346273postfire
postgrad1245493postgra_d
postgrads1344873postgrads
posthaste1456603posthaste
posthole1339533posthole
postiche1547793postiche
postie84123963post__ie
postique1945873postique
postlude1144543postlude
postman112410043postma_n
postmark1645433postmark
postoral10311723postora_l
postpaid1376543postpaid
postpone1248693postpone
postpose1247653postpose
postrider1246653postrider
postriot10412253postriot
posttax1645533postta_x
postulate1169813postulate
postural1049203postura_l
posture9313253post_ure
postwar1236903postwa_r
potage92715903po_t_age
potence11711363po_tence
potlach14106363po_tlach
potlache15114283po_tlache
pottage103310603po_ttage
prerace11414123p_rerace
prostate10314533prost_ate
prostrated1349423prostrated
prostrates12411993prostrates
protract12510603protract
protrade1148213protrade
retrace91417343_retrace
rostra6310933rostra__
rostral7311333rostra_l
strafe95215983__strafe
strake104017393__strake
trace75829613___trace

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 Filter1786911461620.456391866.2
2DLD Change Limit1461621188.06318127.5
3Display Results1181180.0601966.7
 (SQL Overall)1786911188.57920828.9
 
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.