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

156 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
interact1031647(None) 
interacts11312121interacts
inexact1647412in_exact
infract12610002in_fract
intact8314662int__act
integrant1049832integrant
interacted13411212interacted
interage9314492interage
interarch1446722interarch
intercut10411112intercut
interdict12410212interdict
interest8319182interest
interface14410172interface
interject1849602interject
interlace11311912interlace
intermat101114612intermat
intermit101213592intermit
interrace11312552interrace
intersect11412112intersect
intrant7318752int_rant
intreat7416302intrea_t
iterant7317782i_terant
underact11311512underact
alterant8614963alterant
antepast1048293antepast
artefact1345183artefact
attract9511833_attract
cataract1249413cataract
contract122915633cont_ract
counteract1449603counteract
detract101414633det_ract
distract11313023dist_ract
entera64216833entera__
enteral73516443entera_l
enteric9314213enteric_
enterics10312853enterics
entrant7318873ent_rant
entreat7315263entrea_t
extract16311013ext_ract
icteric1138023icteric_
icterics1247053icterics
indirect1147523indirect
indraft1199573in_draft
inerrant8412493inerrant
inert53234373in_er__t
infarct1249013infar_ct
infect113413443infe__ct
infracts1346623in_fracts
ingraft1199503in_graft
inherent11412793inherent
inherit10312973inher_it
inject153210233inje__ct
insect83916583inse__ct
insert64325253inser__t
instruct1047543instruct
insurant8411433insurant
integral946783integra_l
integrals1046463integrals
integrand1145033integrand
integrants1146693integrants
integrate10911153integrate
intellect1147443intellect
intendant1047713intendant
intent63122773inte__nt
inter55028493inter___
interactant1357043interactant
interacting14411713interacting
interaction13411813interaction
interactive1659633interactive
interbank1547043interbank
interbed112413103interbed
intercaste1249283intercaste
intercept13410963intercept
intercity14410003intercity
intercom1248683intercom
intercuts1148783intercuts
interdicts1347083interdicts
interests9312553interests
interfaced1647943interfaced
interfaces15410413interfaces
interfaith1645923interfaith
intergang11117893intergang
intergraft1446173intergraft
interim9912873inter_im
interims101013073interims
interior8513093interior
interjects1947533interjects
interknit1358333interknit
interknot1356903interknot
interlaced1349233interlaced
interlaces12412053interlaces
interlaid1049353interlaid
interlap1048593interlap
interlaps1148233interlaps
interlard1048453interlard
interlay11310043interlay
interlays1248083interlays
interlent9416733interlent
interlock1546233interlock
intermale11712303intermale
intermats111412453intermats
interment11419223interment
intermits111212203intermits
intermix17156873intermix
intermont11513573intermont
intern64016543inter__n
internal8414083internal
internals9712723internals
interne73218153inter_ne
interned93016653interned
internee82718523internee
internes82721233internes
internist9414883internist
interns73116773inter_ns
interparty1546853interparty
interplant12119573interplant
interpret11413363interpret
interred92615263interred
interrex15249823interrex
interrow1147133interrow
interrupt1147243interrupt
inters64328053inter__s
intersects1249153intersects
intersex15209733intersex
interspace1446153interspace
intertie8317613intertie
interunit959833interunit
interval11710463interval
intervale12911593intervale
intervals12810143intervals
interwar1148263interwar
intestacy1444133intestacy
inthral10249463inthra_l
inthrall11247063inthrall
inthrals11258503inthrals
intimacy1544903intimacy
intolerant1056143intolerant
intort6418923intor__t
intracity1448423int_racity
intranet8418443int_ranet
intrants8312863int_rants
intreats8311543intreats
intrench1396593intrench
introit7414533int_roit
intrust7311493int_rust
invert94120083inver__t
inveteracy1852193inveteracy
iterance1049523i_terance
iterate71119113i_terate
literacy1346803literacy
overact12315043_overact
retract91318113ret_ract
tract75635713__t_ract
underacts1248583underacts
unteach1246143unte_ach
untrack1338703unt_rack

Search took 9 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.830215290.4
2DLD Change Limit1461621567.81318707.5
3Display Results1561560.0602600.0
 (SQL Overall)1786911568.70320532.1
 
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.