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

62 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
postform155622(None) 
postforms1644601postforms
pisiform1564972pisiform
platform1544592platform
postfire1346272postfire
postformed1842922postformed
ausform1245243aus_form
coliform1545573coliform
conform14310463co_nform
ensiform1344363ensiform
fusiform1643993fusiform
gasiform1444313gasiform
iodoform1442793iodoform
isoform1244963_isoform
misform1437513mis_form
oviform1544823_oviform
paraform1546943paraform
pastor84817483past_or_
pastors94119003past_ors
pediform1645193pediform
perform1439293p_erform
piciform1765003piciform
piliform1555483piliform
piriform1555763piriform
pisciform1843263pisciform
pisiforms1643503pisiforms
planform1544763planform
platforms1643213platforms
postbox1885493postbo_x
postboy1476673postbo_y
postboys1585273postboys
postburn1243923postburn
postcard1346523postcard
postcode1346323postcode
postcoup1443863postcoup
postdoc1245263postdo_c
postdocs1345273postdocs
poster84129173post_er_
postern93615613post_ern
posters93928013post_ers
postface1566123postface
postfix1944683postf_ix
postforming1953263postforming
posthole1339533posthole
postmark1645433postmark
postmortem1653433postmortem
postop10511943post_o_p
postops11311713post_ops
postoral10311723post_oral
postpone1248693postpone
postpose1247653postpose
posture9313253post_ure
postwar1236903postwar_
preform1439623p_reform
proreform1643913proreform
pyriform1844413pyriform
restiform1443973restiform
rootworm1344813rootworm
rotiform1344673rotiform
storm76520403__st_orm
ursiform1343763ursiform
vasiform1644243vasiform

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.420425454.8
2DLD Change Limit146162627.72018932.9
3Display Results62620.0331878.8
 (SQL Overall)178691628.17321863.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.