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

65 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
intertropical176273(None) 
intercortical1764403intercortical
interproximal2461863interproximal
intertrial1049513intertr__i_al
intertribal1354683intertr__ibal
anthropical1855344ant__hropical
interlocal1247094inter_lo__cal
interorbital1453624interor_bital
interprovincial2271064interprovincial
interracial1357074inter_raci_al
interterminal1554304interterminal
intertidal1147714intert___idal
nontropical1555274_n_ontropical
antientropic1663225antientropic__
enterococcal1572315enteroco_ccal
enteroviral1452815ente__roviral
hypertypical2762575hypert_ypical
icterical1347215icte__r__ical
immethodical2261325imme_thodical
inertial8411725in_ert___i_al
inotropic13106425in__otropic__
insertional1147465insertio__nal
intentional11128845intentio__nal
interatomic1553845interatomic__
intercoastal1463985inter_coastal
intercolonial1563975intercoloni_al
intercostal1365765inter_co_stal
intercrop1345765intercrop____
intercropped1952765intercrop_ped
intercropping2052805intercropping
intercrops1446005intercrop___s
interfacial1656295inter_faci_al
interfluvial1852675interfluvi_al
interglacial1554035interglaci_al
interionic1248255inter_ionic__
interlooping1554315interloopi_ng
interloping1446965inter_lopi_ng
intermarginal1672905intermarginal
intermodal1346185inter_mo__dal
internodal1145875inter_no__dal
internuncial1453445internunci_al
interparochial21111675interparochial
interpluvial1752835interpluvi_al
interregional1453765inter_regional
interrenal1049815inter_r__enal
intersocietal1562415inter_societal
interstadial1354085interstadi_al
interstitial1255635interstiti_al
intertextual1953725intert_extual
intertill9410425intert___i_ll
intertroop1253625intertro___op
interzonal1946815inter_zo__nal
intestinal1047515intest___inal
intrinsical1353485int_r_insical
inventorial1453985invent_ori_al
isentropic1453485i_sentropic__
isentropically2162695i_sentropically
luteotropic1553735luteotropic__
mineralogical1862285min_eralogical
neotropic1367715_n_eotropic__
neotropics1475175_n_eotropic_s
pantropical1764345__pantropical
semitropical1872465_semitropical
subtropical1752355__subtropical
tropical1248735_____tropical

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790658.37614898.5
3Display Results65650.0461413.0
 (SQL Overall)178691658.56220870.2
 
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.