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

257 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
intact831466(None) 
contact1144020682contact
enact73525362en_act
impact122310452impact
inapt73522692in_apt
incant82418512incant
indict93115572indict
induct93212742induct
inexact1647412inexact
infant92315132infant
infarct1249012infarct
infect113413442infect
infract12610002infract
inject153210232inject
inlace82513042inlace
insect83916582insect
instant7815352instant
intactly1344742intactly
intake10510862intake
intent63122772intent
interact10316472interact
intort6418922intort
intrant7318752intrant
intuit6314082intuit
outact8317202outact
tact67349032__tact
untack1239762untack
act59557843___act
anlace82513923anlace
anta46839583anta__
antacid10311223antacid
antae56828293anta_e
antas55432033anta_s
antic75728863antic_
antick124814583antick
antics84621453antics
attach11118393attach
attack12148153attack
attract9511833attract
bract96332723_bract
cineast9310523cineast
coact96130583_coact
contacts123215213contacts
contract122915633contract
detach12310413detach
detect94217403detect
detract101414633detract
didact10711203didact
diktat11310693dikta_t
distant83519953distant
distract11313023distract
enacts84012973en_acts
enface112510353enface
enlace82213233enlace
enrapt8313013enrapt
entail61114343entail
entice81316863entice
entrant7318873entrant
epact94921533_epact
exact143516933_exact
extant132714753extant
extract16311013extract
fact97142543__fact
fantast10311703fantast
finback1865823finback
gnat56034433gn_a_t
ictic9311803ictic_
ikat87626643i_ka_t
ileac75814173ileac_
iliac75013493iliac_
impacts13266503impacts
impart102715143impart
inane52820343in_ane
inarch1139173inarch
inarm7314423in_arm
incage93513623incage
incants92012803incants
incase83615283incase
incent83320723incent
incept102712753incept
incest82918743incest
inch95420823in__ch
incitant10810083incitant
incult82414773incult
indaba935633indaba
indent73021243indent
indicts103210723indicts
indraft1199573indraft
induce93811533induce
inducts10259573inducts
indult73614033indult
inearth1037043inearth
inept73622153in_ept
inert53234373in_ert
infall939403infall
infamy1435653infamy
infancy1546173infancy
infanta10237253infanta
infante101910883infante
infants102210773infants
infarcts1345233infarcts
infare9313083infare
infects12279713infects
infest93315433infest
inflect1249223inflect
inflict1248623inflict
infracts1346623infracts
ingate73018243ingate
ingest73119003ingest
ingot61221063in_got
ingraft1199503ingraft
inhabit1277403inhabit
inhale9411513inhale
inhaul936803inhaul
inia45024703inia__
injects16257453injects
inkjet1737453inkjet
inkpot1237813inkpot
inlaced10239873inlaced
inlaces92512903inlaces
inlaid7310143inlaid
inland7310313inland
inlay85214323inla_y
inlays9389873inlays
inlet53732403in_let
inmate82917363inmate
inmost8411363inmost
innage73011573innage
innate63917313innate
input7314653in_put
insane6314893insane
insects93710843insects
insert64325253insert
inset54430863in_set
insist6314513insist
inspect1138463inspect
instal6712193insta_l
install779363install
instals7611713instals
instance1049883instance
instancy1346573instancy
instants8910153instants
instar6310013insta_r
instars7411133instars
instate71616483instate
instinct1048723instinct
instruct1047543instruct
insult62813673insult
intagli845023intagli
intakes11310943intakes
intend72310373intend
intents72115703intents
inter55028493int_er
interacts11312123interacts
intercut10411113intercut
intern64016543intern
inters64328053inters
inti46626083int__i
intima81910033intima
intimacy1544903intimacy
intime81014273intime
intine61021983intine
intis55121643int_is
into45026153int__o
intomb1036403intomb
intone61115433intone
intorts7310973intorts
intown936153intown
intracity1448423intracity
intranet8418443intranet
intrants8312863intrants
intreat7416303intreat
intro54915853int_ro
introit7414533introit
intron64215023intron
intros64215773intros
intrust7311493intrust
intuits7310313intuits
inturn63411563inturn
intwist1038043intwist
invade10157853invade
invar839513inva_r
invars9310003invars
invent93316363invent
invert94120083invert
invest93014843invest
inwall938343inwall
inward10310333inward
iota45127833iota__
iotas54821113iota_s
isotach1244953isotach
itch95619173i_t_ch
knack104311043kn_ack
linac7315413lin_ac_
linacs8310813lin_acs
mintage101110123mintage
misact10316693misact
mutant8317693mutant
natant6318733natant
natch105018223_natch
neat46356783_nea_t
nitwit938593nitwit
nonfact1248893nonfact
nutant6316383nutant
obtect10129633obtect
octant81216553octant
ontic74418573ontic_
outacts9310213outacts
pact86648723__pact
pataca10311193pataca
pinnace113510313pinnace
pinta75727053pinta__
pintada1096083pintada
pintado1096573pintado
pintail9311183pintail
pintano998993pintano
pintas85021393pinta_s
preact103220393preact
qintar15359143qinta_r
qintars16268573qintars
react74634333_react
redact9419043redact
retack122612823retack
retract91318113retract
snack114718063sn_ack
snatch114310603snatch
stack114421693_stack
stacte82113913_stacte
start55642313_start
stat47352693_sta_t
tace65342513__tace
tacet75840023__tacet
tach96132753__tach
tacit76333673__tacit
tack106536293__tack
taco67031353__taco
tacts76524123__tacts
tart47566183__tart
tat37690293__ta_t
taut47048963__taut
tictac1036563tictac_
tictacs1145793tictacs
tinct76126233tin__ct
tract75635713_tract
uintaite8127353uintaite
unapt710421593un_apt
uncast84215713uncast
unhat81119263unha_t
unlace82215173unlace
unpack1457833unpack
unstack1337373unstack
untacks1357503untacks
untame82513603untame
unteach1246143unteach
untrack1338703untrack
untuck1236403untuck
vintage11128143vintage

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162575.14321916.4
3Display Results2572570.0763381.6
 (SQL Overall)1786912575.59231954.8
 
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.