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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
interchange1710458(None) 
interchanged19103441interchanged
interchanger1883461interchanger
interchanges1894261interchanges
interchangers1972642interchangers
interchannel1752532interchannel
counterchange2194863counterchange
interabang1344483interabang_
interabangs1453123interabangs
interage9314493inter__a_ge
intercaste1249283interc_aste
interchain1546643intercha_in
interchanging2052993interchanging
interclan1148603interclan__
intergang11117893inter_gang_
interphase1546003interpha_se
interstage1176403intersta_ge
undercharge1863863undercharge
counterchanged23103774counterchanged
counterchanges22124224counterchanges
countercharge2194294countercharge
exchange21124324___exchange
gearchange1752234_gearchange
hypercharge2553054hypercharge
inarching1546344in_arching_
inheritance1654114inheritance
intendance1345724inte_ndance
interactant1357044interactan_t
interactants1464504interactants
interacting14411714interacting_
interarching1845014interarching_
interbank1547044inter_ban_k
interbranch1853544interbranch
intercalate13117704intercalate
intercede121210984interc__ede
interceding1568044interceding_
interchangeable23161414interchangeable
interchangeably26141584interchangeably
interchurch2151574interchurch
interclass1247004intercla_ss
intercounty1654694intercounty
intercouple1564684intercouple
intercourse1355024intercourse
intercrater1349234intercrater
interface14410174inter_fa_ce
intergrade1247364intergra_de
interlace11311914inter_la_ce
interleave1347614interlea_ve
interline91218014inter_lin_e
interloan948774interloan__
interloans1048264interloan_s
intermale11712314inter_ma_le
intermingle1445764inter_mingle
interne73218154inter___n_e
internee82718524inter___nee
interning10315254inter_ning_
interocean1246484interocean__
interoceanic1653874interoceanic
interphases1646154interphases
interplant12119574interplan_t
interplanted1545054interplanted
interplants13116754interplants
interrace11312554inter_ra_ce
interring10315424inter_ring_
interrobang1453654interrobang_
interrobangs1552684interrobangs
interspace1446154interspa_ce
interstate10710974intersta_te
intertwine1347614intertwin_e
intervale12911604inter_va_le
intervene12912254inter_ven_e
interweave1646254interwea_ve
interzone1849364inter_zon_e
intrenching1744074intrenching_
iterance1049524i_ter__ance
overcharge1944424_overcharge
perchance1866394__perchance
rechange1458184__re_change
supercharge19114244supercharge
undercharged2073504undercharged
undercharges1963634undercharges
unteachable1845744unteachable
unteaching1645494unteaching_

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 Filter1786911488190.436409841.7
2DLD Change Limit148819839.20316170.7
3Display Results83830.0461804.3
 (SQL Overall)178691839.68518450.3
 
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.