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

76 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
preponderancies227156(None) 
preponderances2162271preponderanc_es
preponderance2062382preponderanc_e_
preponderancy2371963preponderanc__y
preponderates18243673prepondera__tes
preponderant1762994preponderan___t
preponderantly2271664preponderan_tly
preponderate17193884prepondera__te_
preponderated19233404prepondera__ted
preponderating2062584prepondera_ting
preponderation19103224prepondera_tion
preponderations20112874preponderations
prepotencies1884294prepo_te__ncies
dependencies1854085_depende__ncies
despondencies1962145desponde__ncies
pendencies1547025p_e__nde__ncies
precedencies1953725pre_cede__ncies
predominancies2161955predo_minancies
pregnancies1644565pre_gn___ancies
preoccupancies217855pre_occupancies
preponderately22101925prepondera_tely
presidencies1754485pre_side__ncies
reconveyances2362425_reconveyanc_es
redundancies1651955_redund__ancies
regeneracies1553745_regen_era_cies
remonstrances1752995_remonstranc_es
codependencies2262186codepende__ncies
conservancies2054116___conservancies
conversancies2053596___conversancies
degeneracies1653556_degen_era_cies
dependances1754856_depend__anc_es
dependences1745886_depende__nc_es
despondences1853396desponde__nc_es
endurances1344936__e__nduranc_es
federacies1644996_fe___dera_cies
generalcies1454046_ge__n_eralcies
immoderacies1992476_immo_dera_cies
imponderables2061376_impondera_bles
independencies2062686independe__ncies
itinerancies1452796__itin_erancies
mendicancies1952226_me__ndicancies
opponencies1752696_oppon_e__ncies
pederasties1452886p_e___derasties
penetrances1544806p_e__netranc_es
permanencies1853566perman_e__ncies
perseverances2061846p_erseveranc_es
pertinencies1654576pertin_e__ncies
prebendaries1752816prebend__a_ries
precedences1845516pre_cede__nc_es
precipitancies2262426pre_cipitancies
preclearances1962066pre_clearanc_es
predominances2093296predo_minanc_es
preferences1876186pre___ferenc_es
prefinances1875016prefin___anc_es
prepuberties1892046prep_uber__ties
presentences1655696presente__nc_es
protuberances1961266pr_otuberanc_es
provenances1854536pr__o_venanc_es
recondenses1444966_reconde__n_ses
reconveyance2262506_reconveyanc_e_
recreancies1544656_re__cre_ancies
redolencies1454566_redo_le__ncies
reentrances1345176_re_en_tranc_es
regnancies1345416_re_gn___ancies
reinsurances1452816_re_insuranc_es
relevancies1654336_re___levancies
remonstrance1653406_remonstranc_e_
repellencies1663076_repelle__ncies
repentances1556116_repen__tanc_es
repugnancies1752086_rep__ugnancies
residencies1445976_re_side__ncies
resonances1246876_reson___anc_es
resplendencies1961606_resplende__ncies
tendencies1346346_te__nde__ncies
trenchancies1952526tre__n_chancies
treponematoses1811916trepon_ematoses

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.360496363.9
2DLD Change Limit95024768.83010761.5
3Display Results76760.0461652.2
 (SQL Overall)178691769.23619347.2
 
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.