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

114 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
intermit10121359(None) 
intermat101114611intermat
intermits111212201intermits
intermix17156871intermix
inherit10312972inher_it
interact10316472interact
intercity14410002intercity
intercut10411112intercut
interdict12410212interdict
interest8319182interest
interim9912872inter_im
interims101013072interims
interknit1358332interknit
intermats111412452intermats
interment11419222interment
intermont11513572intermont
internist9414882internist
intertie8317612intertie
interunit959832interunit
introit7414532int_roit
intromit1048742intromit
endermic1356173endermic
enteric9314213enter_ic
hermit11519443__hermit
icteric1138023icter_ic
inert53234373in_er__t
inertia7410203in_ertia
infirmity1743273infirmity
inherent11412793inherent
inherits11310103inher_its
innermost1144583innermost
insert64325253inser__t
intarsia845763intarsia
integrant1049833integrant
integrity1345173integrity
intensity1247203intensity
intent63122773inte__nt
inter55028493inter___
interacts11312123interacts
interage9314493interage
interbed112413103interbed
intercept13410963intercept
intercom1248683intercom
intercuts1148783intercuts
interdicts1347083interdicts
interests9312553interests
interfaith1645923interfaith
interfile12411043interfile
interfirm1446443interfirm
interior8513093interior
interject1849603interject
interjoin1647893interjoin
interknits1456203interknits
interknot1356903interknot
interlaid1049353interlaid
interlap1048593interlap
interlay11310043interlay
interlent9416733interlent
interline91218013interline
interlink131310663interlink
intermale11712303intermale
intermedin1347443intermedin
interments12716213interments
intermesh1446703intermesh
intermitted1476503intermitted
intermitter1366193intermitter
intermixed2046103intermixed
intermixes1948393intermixes
intern64016543inter__n
internal8414083internal
interne73218153inter_ne
interned93016653interned
internee82718523internee
internes82721233internes
interning10315253interning
internists10410243internists
internment12412253internment
interns73116773inter_ns
interpoint12411883interpoint
interpret11413363interpret
interred92615263interred
interrex15249823interrex
interring10315423interring
interrow1147133interrow
interrupt1147243interrupt
inters64328053inter__s
intersect11412113intersect
intersex15209733intersex
interties9320333interties
intertill9410423intertill
intertwist1356303intertwist
interval11710463interval
interview1547363interview
interwar1148263interwar
intimist10410213int_imist
intort6418923intor__t
intrant7318753int_rant
intreat7416303int_reat
intrepid1145363intrepid
introits859713int_roits
intromits1166213intromits
intrust7311493int_rust
intuit6314083int__uit
inverity1447963inver_ity
invert94120083inver__t
invertin11910233invertin
iterant7317783i_terant
niterie7313743niter_ie
permit10321683__permit
pretermit1347133pretermit
termite9313893__termite
territ63421373__territ
thermit12312013_thermit
underlit91311533underlit

Search took 7 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621146.39022873.6
3Display Results1141140.0502280.0
 (SQL Overall)1786911146.86026048.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.