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

74 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
interstratified19795(None) 
interstratifies1871111interstratifies
interstratify1963073interstratif__y
unstratified1652234un___stratified
intensified15104015intens____ified
intergrafted1753945inter_gra__fted
interstate10710975interst_at___e_
interstates11710205interst_at___es
interstation12410415interst_at__ion
interstrain1155865interstra___i_n
interstrand1254415interstra____nd
stratified1445175_____stratified
desertified1654106__de_ser_tified
entertained1245176enter_t_a_i_ned
integralities1495516inte__gralities
integrated1289296inte__grat___ed
integrative1547126inte__grati_ve_
intenerated1247016inte_nerat___ed
intensifier14113496intens____ifier
intensifies14105336intens____ifies
interallied1246066inte___ra_llied
intercalated1596326intercalat___ed
intercrater1349236inter_crat___er
interfertile1556426interfer_ti_le_
interfertility2063086interfer_tility
intergraded1445636inter_gra___ded
interiorised1355186interior__i_sed
interiorities1356706interior__ities
interiorized2254576interior__i_zed
intermarried1553636inter__ma_rried
intermatted1476306inter__mat__ted
internalised13127046inter__nali_sed
internalities1358636inter__nalities
internalized22147456inter__nali_zed
interoperative1974366interoperati_ve_
interparticle17132626interpar_ticle_
interpolated1547486interpolat___ed
interpolative1865666interpolati_ve_
interpreted1458176inter_pret___ed
interpretive1775846inter_preti_ve_
interrelated13167466interrelat___ed
interrogated1476376interrogat___ed
interrogative17104986interrogati_ve_
interrogatives18133476interrogati_ves
interrogatories1671986interrogatories
intersected1448286inters_ect___ed
interservice1754076interser_vi_ce_
interspaced1644536inters_pa___ced
interspecific2261946inters_pecifi_c
interstadial1354086interst_a__dial
interstadials1462536interst_adi_als
interstage1176406interst_a___ge_
intersterile1254286interst_eri_le_
intersterility1762506interst_erility
interstice1249606inters___ti_ce_
interstices1348526inters___ti_ces
interstitial1255636inters___titial
interstitially1763186interst_itially
intertilled1245816inte___r_tilled
intertwined1544596inter_t__wi_ned
intertwisted16113066inter_t__wisted
intestacies1355306inte_st_a__cies
intestate9159876inte_st_at___e_
intestates10159436inte_st_at___es
overstrained1645276_overstra_i_ned
retestified1554286rete_s___tified
stratifies1346746_____stratifies
terrified13147576__ter__r__ified
testified1397846__te_s___tified
uncertified17124626unce___r_tified
understaffed2052816underst_a__ffed
understated1347836underst_at___ed
ungentrified1752396unge_ntr__ified
unrestrained1353286unre_stra_i_ned

Search took 9 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 Limit95024747.85612095.7
3Display Results74740.0501480.0
 (SQL Overall)178691748.26621617.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.