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

116 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
intermittencies196170(None) 
intermittences1872691intermittenc_es
intermittence1772872intermittenc_e_
intermittency2062323intermittenc__y
intermittent1455324intermitten___t
intermittently1961964intermitten_tly
intermitters1454604intermitte___rs
impermanencies2261575imperm_anencies
impertinencies2062145imperti_nencies
incompetencies2263415in_competencies
inconsistencies19132595inconsistencies
inefficiencies2462115in_efficiencies
inexistences2154015in_e_xistenc_es
inherencies1656475inher____encies
inheritances1753925inher_i_tanc_es
insistencies1454055in___sistencies
intelligences16183685intelli_genc_es
interferences1855475inter_ferenc_es
intermediacies19102335interm_ediacies
intermingles1574395intermi___ngles
intermitted1476505intermitt____ed
intermitter1366195intermitt____er
intermitting1547255intermitt___ing
intermixtures2252045intermixt__ures
interspecies1655095inter__spe_cies
persistencies1752565__persistencies
advertencies1853026adver___tencies
astringencies1662086ast_r_ingencies
detergencies1654356deter___gencies
determinacies1853196determi__nacies
eminencies1445936___e_mi_nencies
emittances1443826___e_mittanc_es
imminencies1753966i___mmi_nencies
immittances1752456i___mmittanc_es
impenitences1854026impe_ni_tenc_es
impercipiences2461516impercipienc_es
impermanences2162476imperm_anenc_es
impertinences1953596imperti_nenc_es
impotencies1754586i____mpotencies
inadvertencies2061676in_advertencies
incipiencies1853716in___cipiencies
inclemencies1853666inclem___encies
incompetences21154526in_competenc_es
inconsistences1883726inconsistenc_es
incontinencies18163756inconti_nencies
incumbencies2053176in_cum__bencies
indecencies1655826inde____cencies
indehiscences2162656inde_hiscenc_es
independencies2062686inde_pendencies
indeterminacies2061816indetermi__nacies
indigencies1555766in___di_gencies
inerrancies1355056in_er___rancies
inexistence2054216in_e_xistenc_e_
inexpediencies2662166in_expediencies
inferences15410356infer____enc_es
infirmities16114506infirmi_t___ies
infrequencies2762486in_fr_equencies
inhabitancies2061626in_habi_tancies
inherences1568976inher____enc_es
inheritance1654116inher_i_tanc_e_
inheritresses16102106inher_itre_sses
inheritrices1752746inher_i_tric_es
insentiences1455466inse__ntienc_es
insistences1355586in___sistenc_es
insufficiencies2571286insufficiencies
insurgencies1553586insur___gencies
integrities1247786integri_t___ies
intelligence15193866intelli_genc_e_
intelligencer16182776intelli_genc_er
intelligencers17211996intelli_gencers
intemperances1953156inte_mperanc_es
intensities11108916intensi_t___ies
interference1756016inter_ferenc_e_
interinfluences2071216interinfluenc_es
interiorities1356706inter_i_orities
interlines101116456interli___n__es
intermarries1454856interm___arries
intermatted1476306intermatt____ed
intermatting1547176intermatt___ing
intermeddles1652886interm___eddles
intermediaries1782526interm_ediaries
intermedins1447386interm___e_dins
interments12716216interm___en__ts
intermeshes1645566interm___e_shes
intermetallics1862186interm_etallics
intermingle1445766intermi___ngle_
intermingled1653456intermi___ngled
intermitotic1653116intermi_t_oti_c
intermits111212206intermi_t_____s
intermixes1948396intermi_____xes
intermixture2152456intermixt__ure_
intermontane1464566intermontan__e_
internuncios1452706inter___nuncios
interstices1348526inter__st_ic_es
interties9320336inter___t___ies
intertwines1446646inter__twin__es
intervenes131012656inter___ven__es
interviewees1853116intervi__e_wees
intestacies1355306inte___st_acies
intraspecies1662806int_r_aspe_cies
intrenches1545816int_r____enches
intricacies1554476int_r_i__cacies
intromittent1462916intromitten___t
intromitters1452176intromitte___rs
intumescences1983666int_umescenc_es
inverities13410626inver_i_t___ies
irritancies1353346i___rri_tancies
permanencies1853566__perm_anencies
permittees1444246__permitte___es
persistences1653866__persistenc_es
pertinencies1654576__perti_nencies
remittances1554006__re_mittanc_es
renitencies1346096__re_ni_tencies
stridencies1454036_st_r_i_dencies
stringencies1553526_st_r_ingencies
termitaries1345696__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 Limit950241169.20310325.3
3Display Results1161160.1101054.5
 (SQL Overall)1786911169.65618505.7
 
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.