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

127 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
interacts1131212(None) 
interact10316471interact_
infracts1346622in_fracts
integrants1146692integrants
interacted13411212interacted
intercuts1148782intercuts
interdicts1347082interdicts
interests9312552interests
interfaces15410412interfaces
interjects1947532interjects
interlaces12412052interlaces
intermats111412452intermats
intermits111212202intermits
intersects1249152intersects
intrants8312862int_rants
intreats8311542intrea_ts
underacts1248582underacts
alterants979103alterants
antepasts1145523antepasts
anthraces1448893anthraces
artefacts1443153artefacts
attracts1047793_attracts
cataracts1345583cataracts
contracts132212013cont_racts
counteracts1547513counteracts
detracts11138833det_racts
distracts1249283dist_racts
enterics10312853enteric_s
entrants8311753ent_rants
entreats839773entrea_ts
extracts1747623ext_racts
icterics1247053icteric_s
indrafts1295583in_drafts
inerts64517023in_er__ts
inexact1647413in_exact_
infarcts1345233infar_cts
infects12279713infe__cts
infract12610003in_fract_
ingrafts12105803in_grafts
inherits11310103inher_its
injects16257453inje__cts
insects93710843inse__cts
inserts74013993inser__ts
instructs1145793instructs
insurants947653insurants
intact8314663int__act_
integrals1046463integra_ls
integrands1244123integrands
integrant1049833integrant_
integrate10911153integra_te
integrates111010783integrates
intellects1245213intellects
intendants1145253intendants
intents72115703inte__nts
interactant1357043interactant
interactants1464503interactants
interacting14411713interacting
interaction13411813interaction
interactions14410463interactions
interactive1659633interactive
interage9314493intera_ge
interarch1446723interarch
interarches1645923interarches
interbeds12238903interbeds
intercaste1249283intercaste
intercepts1448633intercepts
intercity14410003intercity
intercom1248683inter_com
intercoms1349333intercoms
intercut10411113inter_cut
interdict12410213interdict_
interest8319183interest_
interface14410173interfac_e
interfaced1647943interfaced
interfaith1645923interfaith
intergrafts1544413intergrafts
interims101013073inter_ims
interiors9513563interiors
interject1849603interject_
interknits1456203interknits
interknots1455023interknots
interlace11311913interlac_e
interlaced1349233interlaced
interlaps1148233interlaps
interlards1146813interlards
interlays1248083interlays
interlocks1645973interlocks
intermat101114613intermat_
interments12716213interments
intermit101213593intermit_
internals9712723internals
internees93014843internees
internes82721233inter_nes
internist9414883internist
internists10410243internists
interns73116773inter__ns
interparty1546853interparty
interplants13116753interplants
interprets1249333interprets
interrace11312553interrac_e
interrupts1245743interrupts
inters64328053inter___s
intersect11412113intersect_
interspaces1546153interspaces
interties9320333interties
intervales131010513intervales
intervals12810143intervals
inthralls12216233inthralls
inthrals11258503inthra_ls
intorts7310973intor__ts
intracity1448423int_racity
intrados946563int_rados
intranets949263int_ranets
intrant7318753int_rant_
intreat7416303intrea_t_
introits859713int_roits
intrusts837723int_rusts
inverts103211953inver__ts
iterances1148913i_terances
iterant7317783i_terant_
iterate71119113i_tera_te
iterates81317823i_terates
overacts1339653_overacts
retracts101111313ret_racts
tracts85019073__t_racts
underact11311513underact_
untracks1437523unt_racks

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411276.42323142.0
3Display Results1271270.1101154.5
 (SQL Overall)1786911276.93925751.7
 
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.