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 “infect” 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
infect11341344(None) 
infects12279711infects
infest93315431infest
inflect1249221inflect
inject153210231inject
insect83916581insect
affect1448902affect
coinfect15276842coinfect
confect143614272confect
defect124816172defect
effect1437442effect
incent83320722incent
incept102712762incept
incest82918742incest
indent73021242indent
indict93115572indict
induct93212742induct
inept73622152in_ept
inert53234372in_ert
infant92315132infant
infarct1249012infarct
infected14229402infected
infecter13229152infecter
infector13478852infector
infer84215032infe_r
infers93615442infers
infests10279792infests
inflects1336192inflects
inflict1248622inflict
infract12610002infract
ingest73119002ingest
injects16257452injects
inlet53732402inle_t
insects93710842insects
insert64325252insert
inset54430862inse_t
inspect1138462inspect
intact8314662intact
intent63122772intent
invent93316362invent
invert94120082invert
invest93014842invest
refect114319332refect
reinfect1346482reinfect
unfelt92413462unfelt
abject17137703abject
advect12309123advect
affects1535393affects
anent54931843an_ent
aspect10612823aspect
bigfeet1376153bigfeet
bisect10312873bisect
coinfects16344573coinfects
confects153110873confects
connect113515743connect
convect143114483convect
defeat103817163defeat
defects134511523defects
deflect13399973deflect
deject164512843deject
detect94217403detect
dialect101210263dialect
direct93817333direct
disinfect1545043disinfect
disject17268673disject
dissect103614133dissect
effects1535283effects
eject145016043_eject
elect74327033_elect
enact73525363en_act
enface112510353enface
erect74129333_erect
expect1758903expect
exsect1558503exsect
fact97142543__fact
feat76458223__feat
feck134923433__feck
feet75352213__feet
felt75146933__felt
fest74949443__fest
fet66471633__fe_t
finest94321733fin_est
finfoot1347173finfoot
funfest13348083funfest
iciest82914743iciest
idlest74014863idlest
iffiest1337973iffiest
illest63615723illest
impact122310453impact
inanest72115363inanest
inapt73522693in_apt
inarch1139173inarch
incant82418513incant
incents92414533incents
incepts11238293incepts
incests92711383incests
inch95420823in__ch
incult82414773incult
indecent11411273indecent
indeed83913563indeed
indene73215373indene
indents83114663indents
index13310983inde_x
indicts103210723indicts
indirect1147523indirect
induce93811533induce
inducts10259573inducts
indult73614033indult
indwelt1146513indwelt
inerts64517023in_erts
inexact1647413inexact
infall939403infall
infamy1435653infamy
infancy1546173infancy
infanta10237253infanta
infante101910883infante
infants102210773infants
infarcts1345233infarcts
infare9313083infare
infectant1446833infectant
infecters14257583infecters
infecting15109673infecting
infection14410473infection
infective17108973infective
infectors14218553infectors
infecund1442273infecund
infeoff1253263infeoff
inferno1045603inferno
infested12249643infested
infester11239433infester
infield1135823infield
infight1437453infight
infill938413infill
infirm1137043infirm
infix15337773inf_ix
inflate10312313inflate
inflected1546053inflected
inflector1465353inflector
inflicts1345613inflicts
inflow1235293inflow
influent1147623influent
influx1643723influx
info75617353inf__o
infold10128163infold
inform11310153inform
infos84311673inf_os
infra838643inf_ra
infracts1346623infracts
infuse93110573infuse
ingesta8357863ingesta
ingests83210983ingests
ingot61221063in_got
inhere9313713inhere
inherit10312973inherit
injected18226753injected
injector17236933injector
inked104218523inke_d
inker94421093inke_r
inkers104018833inkers
inkiest113415043inkiest
inkjet1737453inkjet
inkpot1237813inkpot
inlace82513043inlace
inlets63915573inlets
inmesh1134863inmesh
inmost8411363inmost
inned64118423inne_d
inner54920633inne_r
inners63919353inners
input7314653in_put
inquest1638603inquest
inseam8329993inseam
insectan1045393insectan
inserts74013993inserts
insets64016133insets
insist6314513insist
inspects1255863inspects
insult62813673insult
inswept1245733inswept
intend72310373intend
intents72115703intents
inter55028493inte_r
interact10316473interact
intercut10411113intercut
intern64016543intern
inters64328053inters
intort6418923intort
intreat7416303intreat
intuit6314083intuit
invected14258883invected
invents102812053invents
inverts103211953inverts
invests10319683invests
islet54527553isle_t
kindest12311503kindest
knelt94617683kn_elt
liefest1038443liefest
linecut997983lin_ecut
liniest73321153liniest
linnet6419423linne_t
minuet82621033minue_t
neat46356783_n_eat
neck105423663_n_eck
nest45548733_n_est
net36670293_n_e_t
nett46643233_n_ett
newt76933743_n_ewt
next116631083_n_ext
nicest82315663nicest
niece74814503_niece
nonfact1248893nonfact
object17135803object
obtect10129633obtect
oncet74626543once_t
onset54730173onse_t
pandect12310953pandect
perfect141010833perfect
piniest93121133piniest
pinkest132812623pinkest
prefect141011073prefect
refects124012743refects
refelt94521423refelt
reflect123913713reflect
reinfects1444723reinfects
reinject1745543reinject
reject154116283reject
resect84424703resect
rifest93114583rifest
ringent8315153ringent
safest95016603safest
sect67443623__sect
select82621173select
sneck114713663sn_eck
tinct76126233tin__ct
tiniest73020123tiniest
unbelt83015693unbelt
unbent83216593unbent
unfed94614223unfe_d
unfence1239193unfence
unfit84518563unf_it
unfixt16398423unfixt
unkent103116053unkent
unkept123710873unkept
unlet54133333unle_t
unmeet83815743unmeet
unmet74426393unme_t
unpent83117373unpent
unrent63219783unrent
unrest62918853unrest
unseat64221023unseat
unsent63820963unsent
unset54532433unse_t
unvext1658173unvext
unwept11389813unwept
unwet84423173unwe_t
viniest103216613viniest
winiest103419693winiest

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.406440125.6
2DLD Change Limit1127162575.62620034.8
3Display Results2572570.0932763.4
 (SQL Overall)1786912576.12529174.0
 
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.