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

77 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
interstratified197951interstratified_
interstratifies1871112interstratifie_s
interstratify1963074interstratif___y
unstratified1652235un___stratified_
intensified15104016intens____ified_
intergrafted1753946inter_gra__fted_
interstate10710976interst_at___e__
interstates11710206interst_at___e_s
interstation12410416interst_at__i_on
interstrain1155866interstra___i__n
interstrand1254416interstra____nd_
stratified1445176_____stratified_
desertified1654107__de_ser_tified_
entertained1245177enter_t_a_i_ned_
integralities1495517inte__gralitie_s
integrated1289297inte__grat___ed_
integrative1547127inte__grati_ve__
intenerated1247017inte_nerat___ed_
intensifier14113497intens____ifie_r
intensifiers15102637intens____ifiers
intensifies14105337intens____ifie_s
interallied1246067inte___ra_llied_
intercalated1596327intercalat___ed_
intercrater1349237inter_crat___e_r
interfertile1556427interfer_ti_le__
interfertility2063087interfer_tili_ty
intergraded1445637inter_gra___ded_
interiorised1355187interior__i_sed_
interiorities1356707interior__itie_s
interiorized2254577interior__i_zed_
intermarried1553647inter__ma_rried_
intermatted1476307inter__mat__ted_
internalised13127047inter__nali_sed_
internalities1358637inter__nalitie_s
internalized22147457inter__nali_zed_
interoperative1974367interoperati_ve__
interparticle17132627interpar_ticle__
interpolated1547497interpolat___ed_
interpolative1865667interpolati_ve__
interpreted1458177inter_pret___ed_
interpretive1775847inter_preti_ve__
interpretively2262937inter_preti_vely
interrelated13167467interrelat___ed_
interrogated1476377interrogat___ed_
interrogative17104987interrogati_ve__
interrogatively2271967interrogati_vely
interrogatives18133477interrogati_ve_s
interrogatories1671987interrogatorie_s
intersected1448287inters_ect___ed_
interservice1754077interser_vi_ce__
interspaced1644547inters_pa___ced_
interspecific2261947inters_pecifi__c
interstadial1354087interst_a__di_al
interstadials1462537interst_a__dials
interstage1176407interst_a___ge__
intersterile1254287interst_eri_le__
intersterility1762507interst_erili_ty
interstice1249607inters___ti_ce__
interstices1348527inters___ti_ce_s
interstitial1255637inters___titi_al
interstitially1763187interst_iti_ally
intertilled1245827inte___r_tilled_
intertwined1544607inter_t__wi_ned_
intertwisted16113067inter_t__wisted_
intestacies1355307inte_st_a__cie_s
intestate9159877inte_st_at___e__
intestates10159437inte_st_at___e_s
overstrained1645277_overstra_i_ned_
retestified1554287rete_s___tified_
stratifies1346747_____stratifie_s
terrified13147587__ter__r__ified_
testified1397847__te_s___tified_
uncertified17124637unce___r_tified_
understaffed2052817underst_a__ffed_
understated1347847underst_at___ed_
ungentrified1752397unge_ntr__ified_
unrestrained1353287unre_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.436409841.7
2DLD Change Limit95024778.08011760.4
3Display Results77770.0601283.3
 (SQL Overall)178691778.57620836.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.