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

260 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
incept10271275(None) 
incent83320721incent
incepts11238281incepts
incest82918741incest
inept73622151in_ept
accept123210622accept
concept133314442concept
discept12310622discept
except1797652except
inapt73522692in_apt
incant82418502incant
incents92414532incents
incepted13177772incepted
inceptor1246022inceptor
incests92711382incests
incipit1158922incipit
incult82414772incult
indent73021242indent
inert53234372in_ert
infect113413442infect
infest93315432infest
ingest73119002ingest
inject153210232inject
inlet53732402inle_t
insect83916582insect
insert64325252insert
inset54430862inse_t
inswept1245732inswept
intent63122772intent
invent93316362invent
invert94120082invert
invest93014842invest
nicest82315662nicest
oncet74626542once_t
recept103319072recept
unkept123710872unkept
unwept11389812unwept
accent105116263accent
accepts13356353accepts
adept81219643_adept
ancient9514733ancient
anent54931843an_ent
ascent84519653ascent
bewept13410323bewept
bicep115413543bicep_
biceps12447713biceps
celt65646713__celt
cent67451013__cent
cep75736333__cep_
cepe84926653__cepe
ceps86125953__ceps
clept95725773_clept
conceit113218073conceit
concent114422513concent
concepti14328253concepti
concepts143110303concepts
concert113325223concert
crept95125893_crept
deceit93018213deceit
decent94023703decent
discepts1336743discepts
docent92918683docent
encrypt1445323encrypt
encyst1136203encyst
enrapt8313013enrapt
excepts1885203excepts
excerpt1845943excerpt
facet106038523face_t
finest94321733fin_est
ice56737243i_ce__
iced78721893i_ce_d
ices66129643i_ce_s
iciest82914743iciest
idlest74014863idlest
illest63615723illest
inanest72115363inanest
incage93513623incage
incants92012803incants
incase83615283incase
incense92410303incense
incented112412543incented
incenter102212083incenter
incepting1489293incepting
inception1348693inception
inceptive1677823inceptive
inceptors1345763inceptors
inch95420823inc__h
inched124514483inched
incher114114033incher
inchers123912523inchers
inches114419673inches
incident11410203incident
incipits1246253incipits
incise83515323incise
incite83618723incite
inclip1036823inclip
inclips1135963inclips
incog838253inc_og
incogs937903incogs
income10712093income
incony1139073incony
increate10312203increate
incrust949203incrust
incubi1035103incubi
incur72212253inc_ur
incurs83012273incurs
incus73315053inc_us
incuse83513573incuse
indecent11411273indecent
indeed83913563indeed
indene73215373indene
indents83114663indents
index13310983inde_x
indict93115563indict
induct93212743induct
indult73614033indult
indwelt1146513indwelt
ineptly1245073in_eptly
inerts64517023in_erts
infant92315133infant
infects12279713infects
infer84215033infe_r
infers93615443infers
infests10279793infests
inflect1249223inflect
ingesta8357863ingesta
ingests83210983ingests
ingot61221063in_got
inhere9313713inhere
inherit10312973inherit
injects16257453injects
inked104218523inke_d
inker94421093inke_r
inkers104018833inkers
inkiest113415043inkiest
inkjet1737453inkjet
inkpot1237813inkpot
inlets63915573inlets
inmesh1134853inmesh
inmost8411363inmost
inned64118423inne_d
inner54920623inne_r
inners63919343inners
innocent1048163innocent
input7314653in_put
inquest1638603inquest
inscape1138013inscape
inseam8329993inseam
insects93710843insects
inserts74013993inserts
insets64016133insets
insist6314503insist
inspect1138463inspect
instep838193instep_
insteps936573insteps
insult62813673insult
intact8314663intact
intend72310373intend
intents72115703intents
inter55028493inte_r
intercept13410963intercept
intern64016543intern
inters64328043inters
intort6418923intort
intreat7416303intreat
intuit6314083intuit
invents102812053invents
inverts103211953inverts
invests10319683invests
irrupt846993irrupt
islet54527553isle_t
kept106232943__kept
kindest12311503kindest
knelt94617683kn_elt
lancet84223573lance_t
lept66440883__lept
linecut997983linecut
liniest73321153liniest
linnet6419413linne_t
lucent8313823lucent
mince95325233mince__
minced114114913mince_d
mincer104017363mince_r
mincers113714843mincers
minces104420803mince_s
minciest122913103minciest
minuet82621033minue_t
miskept1538923miskept
neat46356783_n_eat
neep65728313_neep_
neeps75617883_neeps
nest45548733_n_est
net36670293_n_e_t
nett46643233_n_ett
newt76933743_n_ewt
next116631083_n_ext
nice65534713nice__
nicely1139493nicely
nicer74618293nice_r
nicety1138433nicety
nocent83217413nocent
once65423083once__
onset54730173onse_t
percept133112523percept
pincer104019173pince_r
pincers113916503pincers
piniest93121133piniest
pinkest132812623pinkest
precept133112513precept
receipt1159253receipt
recent83630853recent
recepts113010263recepts
ringent8315153ringent
scent75831623_scent
sept65844363__sept
since75024173since__
sincere9310553sincere
sinciput1244773sinciput
slept75728103_slept
swept105720603_swept
tacet75840023tace_t
tinct76126233tinc__t
tiniest73020123tiniest
unadept1046603unadept
unapt710421593un_apt
unbelt83015693unbelt
unbent83216593unbent
uncap9312283uncap_
uncaps1039813uncaps
uncast84215713uncast
uncleft1257493uncleft
uncut73219173unc_ut
unfelt92413463unfelt
unkempt1544763unkempt
unkent103116053unkent
unlet54133333unle_t
unmeet83815743unmeet
unmet74426393unme_t
unpent83117373unpent
unrent63219783unrent
unrest62918853unrest
unseat64221023unseat
unsent63820963unsent
unset54532433unse_t
unswept1246013unswept
unvext1658173unvext
unwet84423173unwe_t
viniest103216613viniest
wept95635053__wept
wince105220883wince__
winced124415343wince_d
wincer115018193wince_r
wincers123415363wincers
winces114819113wince_s
wincey144110383wince_y
winceys15395523winceys
winiest103419693winiest
yclept1336013yclept
yince105214253yince__
zinced18419413zince_d

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 Filter1786911127160.1231452772.4
2DLD Change Limit1127162606.12618399.6
3Display Results2602600.0932795.7
 (SQL Overall)1786912606.34228175.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.