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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

60 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
predominancies216195(None) 
predominances2093291predominanc_es
predominance1983522predominanc_e_
dominancies1653953___dominancies
predominancy2282743predominanc__y
predominates17125733predomina__tes
dominances1545684___dominanc_es
overdominances2262354overdominanc_es
precipitancies2262424precipitancies
predominant1655124predominan___t
predominantly2162274predominan_tly
predominate16166104predomina__te_
predominated18124814predomina__ted
predominating1964344predomina_ting
predomination1896534predomina_tion
predominations19105544predominations
preeminences1883524pre_eminenc_es
prefinances1875014pre__financ_es
pregnancies1644564pre___gnancies
preliminaries1762504prelimina_ries
prenominates16166164prenomina__tes
prominences1744884pr__ominenc_es
chrominances2152425_chrominanc_es
dominance1446215___dominanc_e_
eminencies1445945__e__minencies
feminacies1745385_fe__mina_cies
geomancies1545745_ge_om__ancies
ordinances1344985or_d__inanc_es
ordonnances1451955or_do_nnanc_es
overdominance2162405overdominanc_e_
permanencies1853565p_e_rmanencies
pertinencies1654585p_e_rtinencies
poignancies1652705p___oignancies
precipitances2163095precipitanc_es
predominately2162325predomina_tely
preeminence1763805pre_eminenc_e_
prefinance1795445pre__financ_e_
prefinanced1983185pre__financ_ed
prefinancing2051945pre__financing
prehominids1952285prehomi__n_ids
prenominate15156635prenomina__te_
prenominated17185205prenomina__ted
prenominating1854695prenomina_ting
prenomination17126755prenomina_tion
prenominations18105765prenominations
preoccupancies217855preoccupancies
preponderancies2271565preponderancies
prepotencies1884295prepo__tencies
presidencies1754485pre__sidencies
prominence1644935pr__ominenc_e_
provenances1854535pr__ovenanc_es
pyromancies2054875p_yrom__ancies
radiancies1345285_rad__i_ancies
redolencies1454565_redo__lencies
redundancies1651955_red_undancies
refinances15107145_re__financ_es
regnancies1345415_re___gnancies
renominates13137805_renomina__tes
repugnancies1752085_re_pugnancies
resonances1246875_reso__nanc_es

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.390458182.1
2DLD Change Limit95024609.17310359.1
3Display Results60600.0302000.0
 (SQL Overall)178691609.59318627.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.