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 “prognostication” with Change Limit: [1] [2] [3] [4] [5] [6]

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

110 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
prognostication208229(None) 
prognosticating2172132prognosticating
prognosticative2381802prognosticative
prognosticator1972182prognosticat_or
prognosticate1882733prognosticat__e
prognosticated2082463prognosticat_ed
prognosticates1972593prognosticat_es
prognosticators2071903prognosticators
procrastination1962454procrastination
constipation1648565_co_n_stipation
domestication18114545_do_mestication
pontification2089005p_o_ntification
predestination1765485pr_edestination
prenomination17126755pr_eno_mination
prenotification2253605pr_enotification
preunification2154305preun_ification
prognostic1554775prognostic_____
prognostics1653725prognostic____s
pronunciation17113225pro_nunci_ation
propitiation1656915pro__piti_ation
proposition1588735pro_pos_i__tion
proselytization29111905proselytization
prostitution1454605pr___ostitution
prostration13410785pr___ost_ration
protestation1456355pro_test__ation
provocation1847345pro_vo___cation
robotization2346865_ro_bo_tization
rustication1349225_r___ustication
sophistication2162765_sophistication
aromatization2457066aro__matization
conglutination1762786_conglutination
connotation1347986_conno_t__ation
consociation1648196_co_nsoci_ation
consolidation1655156_co_nsolidation
conspiration1648376_co_n_spiration
constipations1747676_co_n_stipations
constitution1455266_co_n_stitution
constriction1648256_co_n_stric_tion
cornification2046696_corn_ification
decortication1857536__decortication
diagnostician1771446diagnostic__ian
dogmatization2655966_dog_matization
domestications19143996_do_mestications
erotization20412056er___o_tization
fantastication1962236_fantastication
fornication1645956_forn___ication
instigation1249246___in_stigation
lignification19125706_lign_ification
magnetization2554826_magn_etization
magnification2145766_magn_ification
mastication15610296____mastication
monetization2358116_mo_n_etization
negotiation1245776_neg_o_ti_ation
personification2272386person_ification
phosphatization3462366phosphatization
photooxidation2783186pho_tooxidation
podsolization25165006p_odso_lization
podzolization24194376p_odzo_lization
pontifications2187906p_o_ntifications
postulation13119126p____ostulation
potentiation1455956p_o_tenti_ation
preconviction2253706pr_econvic_tion
predestinations1865006pr_edestinations
predication16412436pr____edication
predomination1896536pr_edo_mination
prefabrication2392826pr_efabrication
premodification2582976premodification
prenominations18105766pr_eno_minations
preordination1656156pr__eordination
preposition15108566pr_epos_i__tion
prepublication2252926pr_epublication
prettification21115716pr_ettification
prevarication2055246pr__evarication
prioritization2584156pr_ioritization
privatization2755866pr__ivatization
procrastinating2072196procrastinating
procrastinator1881936procrastinat_or
progestational1762746prog_est__ational
prolongation1563716pro_lo__ngation
pronation11415706pro_n_____ation
pronunciations18122776pro_nunci_ations
propitiations1756206pro__piti_ations
propositions16108296pro_pos_i__tions
prorogation1447396pro_ro___gation
prosecution1546066pr___os_ecution
prostitutions1554256pr___ostitutions
prostrations1449746pr___ost_rations
protection14511456pr___o_tec_tion
protestations1555786pro_test__ations
protonation13510426pr___o_tonation
protraction1547196pr___o_traction
provocations1956846pro_vo___cations
reconstitution1663556_reconstitution
registration1347536_reg_ist_ration
reinvestigation1962186_reinvestigation
remonetization2555886_remonetization
remonstration15117126_remonst_ration
remotivation1747426_r_emo_tivation
renomination1499186_r_eno_mination
repristination16204106_repristination
reunification18147456_reun_ification
rigidification2173146_rigidification
robotizations2446346_ro_bo_tizations
rustications1448566_r___ustications
signification1986286_sign_ification
sonication12411186_so_n___ication
sophistications2262556_sophistications
translocation1554686tr_an_slocation
transpiration1555426tr_an_spiration
urtication1249116ur_____tication

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 Filter178691950240.1231452772.4
2DLD Change Limit950241109.26610255.1
3Display Results1101100.0801375.0
 (SQL Overall)1786911109.46918871.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.