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

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

92 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
interstratifies1871111interstratifies_
interstratified197952interstratifie_d
interstratify1963074interstratif___y
interstates11710205interst_at___es_
integralities1495516inte__gralities_
intensifies14105336intens____ifies_
interiorities1356706interior__ities_
internalities1358636inter__nalities_
interrogatives18133476interrogati_ves_
interrogatories1671986interrogatories_
interstadials1462536interst_adi_als_
interstate10710976interst_at___e__
interstation12410416interst_at__i_on
interstices1348526inters___ti_ces_
interstrain1155866interstra___i__n
intestacies1355306inte_st_a__cies_
intestates10159436inte_st_at___es_
stratifies1346746_____stratifies_
unstratified1652236un___stratifie_d
desertifies1544707__de_ser_tifies_
enteropathies1863377enter_opat_hies_
geostrategies156977__geostrategies_
impersonalities1963677impersonalities_
inerrancies1355057in_er__ra_ncies_
inferiorities1653727inferior__ities_
infertilities1656217infer_t_ilities_
infestations1546627infe_st_ati_ons_
inheritrices1752747inheritr__i_ces_
inheritrixes2252117inheritr__i_xes_
integrates111010787inte__grat___es_
integrationist1583687inte__grationist
integrations13129477inte__grati_ons_
integrative1547127inte__grati_ve__
integrities1247787inte__gr__ities_
intemperateness1972737intemperat_eness
intenerates1148087inte_nerat___es_
intenerations1347467inte_nerati_ons_
intensified15104017intens____ifie_d
intensifier14113497intens____ifie_r
intensifiers15102637intens____ifiers
intensities11108917intens____ities_
intercalates14117267intercalat___es_
intercalations1655917intercalati_ons_
intercrater1349237inter_crat___e_r
interfertile1556427interfer_ti_le__
interfertility2063087interfer_tili_ty
intergrades1346787inter_gra___des_
intergrafted1753947inter_gra__fte_d
intergrafts1544417inter_gra__f_ts_
interiorises1296887interior__i_ses_
interiorizes2155697interior__i_zes_
intermarriages1761597intermar_riages_
intermarries1454857inter__ma_rries_
internalises12149117inter__nali_ses_
internalizes21138697inter__nali_zes_
interoperative1974367interoperati_ve__
interparticle17132627interpar_ticle__
interpolates1448577interpolat___es_
interpolations1657437interpolati_ons_
interpolative1865667interpolati_ve__
interpretive1775847inter_preti_ve__
interpretively2262937inter_preti_vely
interrelates12148077interrelat___es_
interrelations1457617interrelati_ons_
interrogatees1494177interrogat__ees_
interrogates1387107interrogat___es_
interrogations1556817interrogati_ons_
interrogative17104987interrogati_ve__
interrogatively2271967interrogati_vely
intersections1598967inters_ecti_ons_
interservice1754077interser_vi_ce__
interspaces1546157inters_pa___ces_
interspecies1655097inters___pecies_
interspecific2261947inters_pecifi__c
interstadial1354087interst_a__di_al
interstage1176407interst_a___ge__
intersterile1254287interst_eri_le__
intersterility1762507interst_erili_ty
interstice1249607inters___ti_ce__
interstitial1255637inters___titi_al
interstitially1763187interst_iti_ally
interstrand1254417interstra_____nd
interties9320337inte___r_t__ies_
intertwines1446647inter_t__wi_nes_
intestate9159877inte_st_at___e__
intestines10410257inte_s___ti_nes_
neutralities1246467_n_e_utralities_
retestifies1444537rete_s___tifies_
stratified1445177_____stratifie_d
terrifies12139727__ter__r__ifies_
testifies12139267__te_s___tifies_
understates1247707underst_at___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.343520965.0
2DLD Change Limit95024928.81310782.3
3Display Results92920.0631460.3
 (SQL Overall)178691929.21919382.9
 
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.