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

98 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
prostatisms155587(None) 
prostatism1447741prostatism_
prosaisms1346272pros_a_isms
prostatitis1355872prostatitis
apostatises1364583apostatises
pragmatisms1854663pragmatisms
predatisms1545243pr_edatisms
prelatisms1445703pr_elatisms
presentisms1555213presentisms
privatisms17165953pr_ivatisms
proctitises15106323proctitises
prognathisms2051803prognathisms
prosaism1268043pros_a_ism_
prosaists1157503pros_a_ists
proselytisms1962113proselytisms
prostates11314423prostat__es
prostatic13410853prostati__c
prostatitises1553823prostatitises
prosthetists1753483prosthetists
prostrations1449773prostrations
statisms1039543___statisms
aerostatics1354394aerostati_cs
apostatise1255264apostatis_e
apostatised1473064apostatised
apostatizes2264134apostatizes
boosterisms1553184boosterisms
dogmatisms1643944_dogmatisms
eroticisms1457994ero_ticisms
erotisms10310164ero___tisms
etatisms1038294___etatisms
gnosticisms1673624gnosticisms
iotacisms1346104_io_tacisms
ostracisms1444834__ostracisms
parasitisms1575504paras_itisms
parotitises1346434paro_titises
periostitises1553144periostitises
personalisms1676094personalisms
poeticisms1647344p_oeticisms
positivisms1853844p_ositivisms
postcrisis1454904p_ostcrisis
posttests1144974p_ost_tests
posturists1247074p_osturists
potations111615074p_o_tations
pragmatism1755504pragmatism_
pragmatists1654374pragmatists
predatism1447284pr_edatism_
prelatism1347854pr_elatism_
presentism1447244presentism_
priapisms1545464pr__iapisms
privatises15187404pr_ivatises
privatism16176934pr_ivatism_
privatists15176054pr_ivatists
probations14311084pro_bations
proclaims1545074procla_i_ms
proctitides1664724proctitides
proctitis1348374proctiti__s
prognathism1952074prognathism_
pronations12314034pro_nations
prorations12314464pro_rations
prosaist10611584pros_a_is_t
prosateurs1243064pros_ateurs
prosceniums1752174prosceniums
proselytises1752814proselytises
proselytism1852554proselytism_
prosodists1345944pros_odists
prostate10314534prostat___e
prostheses1546554prost_heses
prosthesis1546154prost_hesis
prosthetics18135204prostheti_cs
prosthetist1655884prosthetis_t
prosties101421194pros__ti_es
prostitutes1345174prostitutes
prostomium1664154prostomium_
prostrates12411994prostrat__es
prostrating1449394prostrati_ng
prostration13410794prostrati_on
protamines14149804pro_tamines
protamins131410774pro_tami_ns
protases102115034pro_ta__ses
protasis102411974pro_ta__sis
protatic12314754pro_tati__c
protestations1555814protestations
protists10313364pro___tists
protiums1238564pro___tiums
puritanisms1554214puritanisms
pyrostats1444914pyrostat___s
restations10315844_restations
rhotacisms1743014_rhotacisms
robotisms1375134_ro_botisms
rosariums11124774_ros_ariums
rotations91613844_ro_tations
routinisms1245784_routinisms
royalisms14127264_ro_yalisms
statism9412284___statism_
statists8310164___statists
totalisms1139814_to_talisms
traumatisms1554054traumatisms
voltaisms1444144_volta_isms

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.406440125.6
2DLD Change Limit148819988.57617353.0
3Display Results98980.0501960.0
 (SQL Overall)178691989.03219784.2
 
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.