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

105 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
interlined11121126(None) 
interline91218001interline_
interliner101311151interliner
interlines101116451interlines
interlinked1644841interlinked
interfiled1447652interfiled
interjoined1944942interjoined
interlaced1349222interlaced
interlend10310112interlen_d
interlinear11145692interlinear
interliners11138692interliners
interlink131310662interlin_k
interlinks14137502interlinks
interloped1347632interloped
intermixed2046102intermixed
interned93016652inter__ned
intertwined1544592intertwined
intervened14109052intervened
underlined121610212underlined
centerline1247043centerline_
centerlines1346993centerlines
datelined1194713date_lined
determined1455823determined
entertained1245173entertained
entrained1089413ent_rained
extermined2045323extermined
hinterland1443473hinterlan_d
inclined1138643in__clined
ingrained1145383in_grained
inherited1348793inher_ited
inshrined1344423inshr_ined
intaglioed1251573intaglioed
interacted13411213interacted
interallied1246063interallied
interbed112413103inter__bed
interbred1248743inter_bred
interbreed1346873interbreed
interceded14138203interceded
interdicted1546223interdicted
interested11410333interested
interfaced1647933interfaced
interfered1448533interfered
interfiber1545803interfiber
interfile12411043interfile_
interfiles1349993interfiles
interflowed1843953interflowed
interfused1445883interfused
interlace11311903interlace_
interlaces12412043interlaces
interlaid1049353interl_aid
interlapped1644093interlapped
interlard1048453interl_ard
interlarded1345233interlarded
interlayer1346923interlayer
interleaved1545863interleaved
interlends1148603interlends
interlent9416733interlen_t
interlinears12144583interlinears
interlining1249133interlining
interlocked1854543interlocked
interlooped1444353interlooped
interlope1149183interlope_
interloper1247473interloper
interlopes1249273interlopes
interlude1047293interlude_
interludes1147393interludes
interlunar1045433interlunar
intermingled1653453intermingled
intermitted1476503intermitted
intermixes1948393intermixes
internalised13127043internalised
internalized22147453internalized
interne73218143inter__ne_
internee82718513inter__nee
internes82721233inter__nes
interning10315253internin_g
interplanted1545053interplanted
interplayed1745243interplayed
interpled1239603inter_pled
interposed1348023interposed
interred92615263inter__red
interring10315423interrin_g
intertie8317613interti_e_
interties9320333interti_es
intertilled1245813intertilled
intertwine1347613intertwine_
intertwines1446643intertwines
intervene12912243intervene_
intervener13109013intervener
intervenes131012643intervenes
interview1547363intervi_ew
interviewed1844143interviewed
interzone1849353interzone_
intestine9411853intestine_
intestines10410253intestines
inthroned1396583inthr_oned
inturned9268313intur__ned
intwined1235463int__wined
underline101714673underline_
underlines111512113underlines
undermined14189133undermined
untrained10510993unt_rained
waterline1249653waterline_
waterlines1348953waterlines
winterized2345713winter_ized

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 Filter1786911406030.406440125.6
2DLD Change Limit1406031056.75020830.1
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.20224811.3
 
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.