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

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
postpollination197177(None) 
pollination1348014____pollination
postposition1654794postpo_si__tion
postvaccination2471304postvaccination
despoliation1546715des_po_li_ation
monopolization2793405monopo_lization
podsolization25165005po_dso_lization
podzolization24194375po_dzo_lization
pollinations1447235____pollinations
postconvention2172125postconven_tion
postisolation1553565postisol__ation
postmillenarian1991585postmillenarian
postpositions1753965postpo_si__tions
postulation13119135post__ul__ation
spoliation1248425__s_po_li_ation
colligation1457446____colligation
collimation1557576____collimation
compellation1855106co_mpell__ation
complication2048196co_mp__lication
consolidation1655156co_nso_lidation
constellation1554796const_ell__ation
contamination1766956cont__amination
coordination1595586co___ordination
crystallization2962246cryst_allization
desalination13411136des___alination
despoliations1646396des_po_li_ations
destabilization2763336destabilization
destination12413846dest____ination
disinclination1763966dis_inclination
distillation1347736dist_ill__ation
foreordination1892286fo_reordination
fossilization2565146fos__silization
hospitalization2963106hospitalization
installation1254906inst_all__ation
instillation1245846inst_ill__ation
insubordination1861796insubordination
metallization24176866_met_allization
misapplication2263346misap_plication
monopolizations2893396monopo_lizations
motorization2349706mo_t_o_rization
oscillation1345496_os_cill__ation
palliation1248506____palli_ation
pasteurization2584446past_eurization
patination12312576p_at____ination
patronization2456746p_atro_nization
pectination15410336pect____ination
phosphatization3462376phos_phatization
photooxidation2783206phot_ooxidation
podsolizations26164376po_dso_lizations
podzolizations25153876po_dzo_lizations
pollinating1445616____pollinating
pollinator1244776____pollinat_or
pontification2089006pont__ification
popularization2754276po__pularization
population14810026po__p_ul__ation
postamputation2061716post_amputation
postconception2282456postco_nception
postdevaluation2171856postdevaluation
postelection1654546post__el_ection
postgraduation1862046post_graduation
postillion1255636post_ill____ion
postinoculation1961846postinoculation
postirradiation1871146postirradiation
postliberation1892056post_liberation
postpositional1862656postpo_si__tional
postpositive1963126postpo_si__tive
postproduction2162896postp_roduction
poststimulation1971746poststimulation
postulations14127736post__ul__ations
potentiation1455976po_t_enti_ation
predomination1896536p_redo_mination
prenomination17126756p_reno_mination
preordination1656156p__reordination
prepublication2252926p_republication
pretermination1854776pret_ermination
protonation13510436prot_o___nation
pustulation13116626pust__ul__ation
ratiocination1574326_ratio_cination
solmization2247326__s__olmization
spallation1247026__s_pall__ation
spoliations1347696__s_po_li_ations
stabilization2466196__stabilization
sterilization2258866__sterilization
strobilation1454046__stro_bilation
stylization2346676__st__ylization
subordination1654176__subordination
supination1249886__sup___ination
supplication1855396__sup_plication

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 Filter178691950240.1231452772.4
2DLD Change Limit95024888.51611158.3
3Display Results88880.0801100.0
 (SQL Overall)178691888.71920494.4
 
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.