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

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
intercolonial156397(None) 
anticolonial1464063ant_icolonial
neocolonial1352553_n_eocolonial
interactional1557004interaction_al
intercensal1356144interc__ensal
intercoastal1463984interco_astal
intercommunal1962554intercommunal
intercortical1764424intercortical
intercostal1365764interc__ostal
intercultural1563844intercultural
interfluvial1852674inter_fluvial
interglacial1554034inter_glacial
interlocal1247094inter__lo_cal
interpluvial1752834inter_pluvial
interzonal1946814inter__zon_al
precolonial1554254_pre_colonial
autecological1854435aute_cological
colonial10411345_____colonial
enterococcal1572315enter_ococcal
insertional1147465inser_tion_al
intensional11146565inte_nsion_al
intentional11128845inte_ntion_al
interannual1154375inter__annual
intercalating1656505intercalating
intercalation1557085intercalation
intercell1148165intercel____l
intercellular1562805intercellular
intercessional1663645intercession_al
interchannel1752535interc_hannel
interclan1148605interc_l___an
intercollegiate1871465intercollegiate
intercommunion2071885intercommunion
intercommunity2381845intercommunity
interconnect1654445interco_nnect
intercooler1345835interco_o_ler
intercoolers1454455interco_olers
intercostals1454605interc__ostals
intercountry1753645interco_untry
intercounty1654695interco_un_ty
interdental1258415inter__dental
interdominion1662635interdominion
interfacial1656295inter__facial
interfamilial1862745interfamilial
interferential1763975interferential
interflowing1953665inter_flowing
interfolding1754585interfol_ding
interglacials1662555inter_glacials
interionic1248255inter__ioni_c
interjectional23195605interjection_al
interjoining2054655interjo_ining
interlinear11145695inter__linear
interlining1249135inter__lining
interloan948775inter__lo__an
interlooping1554315interlo_oping
interloping1446965inter__loping
interlunar1045435inter__lun_ar
intermarginal1672905intermarginal
intermodal1346185inter__mo_dal
internal8414085inter____n_al
international1357675internation_al
interneuronal1362695interneuron_al
internodal1145875inter__no_dal
internuncial1453445inter_nuncial
interoceanic1653875interoceani_c
interorbital1453625inter_orbital
interparochial21111675interparochial
interpersonal1564025interperson_al
interpolating1657795interpolating
interpolation1558555interpolation
interpolative1865665interpolative
interprovincial2271065interprovincial
interproximal2461865inter_proximal
interracial1357075inter__racial
interregional1453765interregion_al
interrenal1049815inter__ren_al
intersectional16146255intersection_al
intersocietal1562415intersocietal
interstadial1354085inter_stadial
interstitial1255635inter_stitial
interterminal1554305interterminal
intertrial1049515inter___trial
intertropical1762735inter_tropical
intracranial1463665int_racranial
intrazonal1954005int_r_azon_al
necrological1747285_n_ecrological
postcolonial1663095_postcolonial
semicolonial1663055_semicolonial
soteriological1763895soteriological
stereological1655675_stereological
supercolossal1761375supercolossal
unecological1745825un_e_cological
watercolorist18182545watercolorist

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 Filter1786911247900.423422437.4
2DLD Change Limit124790929.20313559.7
3Display Results92920.0601533.3
 (SQL Overall)178691929.68618448.4
 
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.