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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
interlace1131190(None) 
interface14410161interface
interlaced1349221interlaced
interlaces12412041interlaces
interrace11312541interrace
interact10316462inter_act
interage9314482inter_age
interfaced1647932interfaced
interfaces15410402interfaces
interlaid1049352interlaid
interlap1048592interla_p
interlaps1148232interlaps
interlard1048452interlard
interlay11310042interla_y
interlayer1346922interlayer
interlays1248082interlays
interleave1347612interleave
interline91218002interline
interlock1546232interlock
interlope1149182interlope
interlude1047292interlude
intermale11712292intermale
interspace1446142interspace
intervale12911582intervale
hinterland1443473hinterland
inference14411023inference
inherence1449263inherence
inlace82513043in___lace
innervate1246593innervate
integrate10911153integrate
intellect1147443intellect
intendance1345713intendance
interacted13411213inter_acted
interacts11312123inter_acts
interarch1446713interarch
interbank1547033interbank
intercalate13117703intercalate
intercaste1249273intercaste
intercede121210983intercede
interclan1148603intercla_n
interclass1246993interclass
interdict12410213interdict
interfere12410813interfere
interfile12411043interfile
interfluve1643873interfluve
interfuse1247433interfuse
intergang11117883intergang
intergrade1247363intergrade
interject1849603interject
interlacing1449053interlacing
interlapped1644093interlapped
interlarded1345233interlarded
interlards1146813interlards
interlayers1445333interlayers
interleaf1248043interleaf
interleaved1545863interleaved
interleaves1447053interleaves
interlend10310113interlend
interlent9416733interlent
interlined111211263interlined
interliner101311153interliner
interlines101116453interlines
interlink131310663interlink
interloan948773interloan
interloans1048263interloans
interlocal1247093interlocal
interlocked1854543interlocked
interlocks1645973interlocks
interloop1145833interloop
interloped1347633interloped
interloper1247473interloper
interlopes1249273interlopes
interludes1147393interludes
intermat101114613interma_t
intermats111412453intermats
internal8414083interna_l
internals9712723internals
interne73218143inter__ne
internee82718513inter_nee
internode1048763internode
interphase1545993interphase
interplant12119573interplant
interplay1447163interpla_y
interplayed1745243interplayed
interplays1545523interplays
interpolate1369333interpolate
interpose11410463interpose
interrelate11188973interrelate
intersect11412113intersect
interspaced1644533interspaced
interspaces1546153interspaces
interstage1176403interstage
interstate10710973interstate
interstice1249593interstice
intertie8317613inter_tie
interval11710453interva_l
intervales131010503intervales
intervals12810133intervals
intervene12912243intervene
interwar1148263interwa_r
interweave1646253interweave
interwove1547143interwove
interzone1849353interzone
intestacy1444133intestacy
intestate9159873intestate
invertase1245823invertase
iterance1049513i_terance
iterate71119113i_ter_ate
terrace93311843__terrace

Search took 8 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 Filter1786911486410.1531167915.0
2DLD Change Limit1486411097.37620152.0
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.57523589.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.