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

99 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
intercompared2012256(None) 
intercompare18103521intercompare_
intercompares19133201intercompares
intercompany21112613intercompa_ny
intercomparing2162283intercomparing
intercalated1596324interc_alated
intercepted16157724interc_ep_ted
intercomparison2171224intercomparison
interconverted2062474interconverted
intercouple1564684intercoup_le_
intercropped1952764intercrop_ped
interlooped1444354interloop__ed
interloped1347634interlo_p__ed
interpolated1547484interpo_lated
interrogated1476374interro_gated
interspaced1644534inter__spaced
catercornered187755catercornered
compared153811825_____compared
interbred1248745inter____bred
intercalary1654735interc_alar_y
intercalate13117705interc_alate_
intercalates14117265interc_alates
intercampus1752585intercamp__us
interceded14138205interc___eded
intercepter15127915interc_ep_ter
intercepters16126395interc_epters
interchanged19103445interc_hanged
intercom1248685intercom_____
intercommunal1962555intercommunal
intercoms1349335intercom____s
interconnected1962275interconnected
interconvert1754885interconver_t
interconverts1853105interconverts
intercooler1345835interco__oler
intercoolers1454455intercooler_s
intercorporate18132805intercorporate
intercorrelated18151955intercorrelated
intercostal1365765intercosta__l
intercostals1454605intercosta_ls
intercountry1753645intercountr_y
intercourse1355015interco__urse
intercourses1454595interco_urses
intercrater1349235interc__rater
intercrossed1553275interc_rossed
interculture1454295interculture_
interfaced1647945inter___faced
interfered1448535inter___fered
interfolded1644625interfo__lded
intergraded1445635inter__graded
interiorised1355185interio_rised
interiorized2254575interio_rized
interjoined1944945interjo__ined
interlaced1349235inter___laced
interlapped1644095inter_lap_ped
interlard1048455inter___lar_d
interlarded1345235inter___larded
interlayered1652715inter_layered
interleaved1545865inter__leaved
interlocked1854545interlo__cked
interlope1149185interlo_p__e_
interloper1247475interlo_p__er
interlopers1346195interlo_per_s
interlopes1249275interlo_p__es
intermale11712305inter__m_ale_
intermarried1553635inter__married
intermarry1564155inter__m_arry
intermatted1476305inter__matted
intermediated1753825intermediated
intermeshed1744365inter__meshed
intermitted1476505inter__mitted
intermixed2046105inter__m_ixed
intermontane1464565intermontane_
interparty1546855inter___party
interpellated1654585interpellated
interpermeated1963215interpermeated
interplayed1745245inter__played
interpleaded1654065inter_pleaded
interpled1239605inter___p_led
interpolate1369335interpo_late_
interpolates1448575interpo_lates
interposed1348025inter___posed
interpret11413365inter___p_ret
interred92615265inter_____red
interrelated13167465inter_related
interrogate1277615interro_gate_
interrogatee1386215interro_gatee
interrogates1387105interro_gates
interrupted1475295inter_rup_ted
interspace1446155inter__space_
interspaces1546155inter__spaces
interspersed1553655inter__spersed
interweaved1844745inter__weaved
interworked1984645interwo__rked
intracompany2161535intracompa_ny
intromitted1452855int_r_omitted
undecomposed2052105unde_composed
undercoated1546825underco__ated
underprepared1961525underprepared
untempered1544045unte___mpered

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.466383457.1
2DLD Change Limit124790998.97013911.9
3Display Results99990.0631571.4
 (SQL Overall)178691999.49918811.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.