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

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

121 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
intermittencies1961701intermittencies_
intermittences1872692intermittenc_es_
intermittence1772873intermittenc_e__
intermittency2062324intermittenc___y
intermittent1455325intermitten____t
intermittently1961965intermitten__tly
intermitters1454605intermitte___rs_
impermanencies2261576imperm_anencies_
impertinencies2062146imperti_nencies_
incompetencies2263416in_competencies_
inconsistencies19132596inconsistencies_
inefficiencies2462116in_efficiencies_
inexistences2154016in_e_xistenc_es_
inherencies1656476inher____encies_
inheritances1753926inher_i_tanc_es_
insistencies1454056in___sistencies_
intelligences16183686intelli_genc_es_
interferences1855476inter_ferenc_es_
intermediacies19102336interm_ediacies_
intermingles1574396intermi___ngles_
intermitted1476506intermitt____e_d
intermitter1366196intermitt____e_r
intermitting1547256intermitt___i_ng
intermixtures2252046intermixt__ures_
interspecies1655096inter__spe_cies_
persistencies1752566__persistencies_
advertencies1853027adver___tencies_
astringencies1662087ast_r_ingencies_
detergencies1654357deter___gencies_
determinacies1853197determi__nacies_
determinateness1861847determinaten__ess
eminencies1445937___e_mi_nencies_
emittances1443827___e_mittanc_es_
imminencies1753967i___mmi_nencies_
immittances1752457i___mmittanc_es_
impenitences1854027impe_ni_tenc_es_
impercipiences2461517impercipienc_es_
impermanences2162477imperm_anenc_es_
impertinences1953597imperti_nenc_es_
impotencies1754587i____mpotencies_
inadvertencies2061677in_advertencies_
incipiencies1853717in___cipiencies_
inclemencies1853667inclem___encies_
incompetences21154527in_competenc_es_
inconsistences1883727inconsistenc_es_
incontinencies18163757inconti_nencies_
incumbencies2053177in_cum__bencies_
indecencies1655827inde____cencies_
indehiscences2162657inde_hiscenc_es_
independencies2062687inde_pendencies_
indeterminacies2061817indetermi__nacies_
indigencies1555767in___di_gencies_
inerrancies1355057in_er___rancies_
inexistence2054217in_e_xistenc_e__
inexpediencies2662167in_expediencies_
inferences15410357infer____enc_es_
infirmities16114507infirmi_t___ies_
infrequencies2762487in_fr_equencies_
inhabitancies2061627in_habi_tancies_
inherences1568977inher____enc_es_
inheritance1654117inher_i_tanc_e__
inheritresses16102107inher_itre_sses_
inheritrices1752747inher_i_tric_es_
insentiences1455467inse__ntienc_es_
insistences1355587in___sistenc_es_
insufficiencies2571287insufficiencies_
insurgencies1553587insur___gencies_
integrities1247787integri_t___ies_
intelligence15193867intelli_genc_e__
intelligencer16182777intelli_genc_e_r
intelligencers17211997intelli_genc_ers
intemperances1953157inte_mperanc_es_
intensities11108917intensi_t___ies_
intensiveness1667487intensi_ven__ess
interestingness1671557inter_estingness
interference1756017inter_ferenc_e__
interinfluences2071217interinfluenc_es_
interiorities1356707inter_i_orities_
interlines101116457interli___n__es_
intermarries1454857interm___arries_
intermatted1476307intermatt____e_d
intermatting1547177intermatt___i_ng
intermeddles1652887interm___eddles_
intermediaries1782527interm_ediaries_
intermedins1447387interm___e_dins_
interments12716217interm___en__ts_
intermeshes1645567interm___e_shes_
intermetallics1862187interm_etallics_
intermingle1445767intermi___ngle__
intermingled1653457intermi___ngle_d
intermitotic1653117intermi_t_oti__c
intermits111212207intermi_t_____s_
intermixes1948397intermi_____xes_
intermixture2152457intermixt__ure__
intermontane1464567intermontan__e__
internuncios1452707inter___nuncios_
interstices1348527inter__st_ic_es_
interties9320337inter___t___ies_
intertwines1446647inter__twin__es_
intervenes131012657inter___ven__es_
interviewees1853117intervi__e_wees_
intestacies1355307inte___st_acies_
intimateness1455797int_im_aten__ess
intraspecies1662807int_r_aspe_cies_
intrenches1545817int_r____enches_
intricacies1554477int_r_i__cacies_
intricateness1564717int_ricaten__ess
intromittent1462917intromitten____t
intromitters1452177intromitte___rs_
intumescences1983667int_umescenc_es_
inverities13410627inver_i_t___ies_
irritancies1353347i___rri_tancies_
permanencies1853567__perm_anencies_
permittees1444247__permitte___es_
persistences1653867__persistenc_es_
pertinencies1654577__perti_nencies_
remittances1554007__re_mittanc_es_
renitencies1346097__re_ni_tencies_
stridencies1454037_st_r_i_dencies_
stringencies1553527_st_r_ingencies_
termitaries1345697__termi_t_aries_

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.343520965.0
2DLD Change Limit950241218.70310918.5
3Display Results1211210.0931301.1
 (SQL Overall)1786911219.13919552.6
 
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.