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

310 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
insect8391658(None) 
infect113413441infect
inject153210231inject
insects93710841insects
insert64325251insert
inset54430861inse_t
inspect1138461inspect
bisect10312872bisect
dissect103614132dissect
exsect1558502exsect
incent83320722incent
incept102712752incept
incest82918742incest
indent73021242indent
indict93115562indict
induct93212742induct
inept73622152in_ept
inert53234372in_ert
infects12279712infects
infest93315432infest
inflect1249222inflect
ingest73119002ingest
injects16257452injects
inlet53732402inle_t
inseam8329992inseam
insectan1045382insectan
inserts74013992inserts
insets64016132insets
insist6314502insist
inspects1255862inspects
insult62813672insult
inswept1245732inswept
intact8314662intact
intent63122772intent
invent93316362invent
invert94120082invert
invest93014842invest
onset54730172onse_t
resect84424702resect
sect67443622__sect
unseat64221022unseat
unsent63820962unsent
unset54532432unse_t
abject17137703abject
absent84016993absent
advect12309123advect
affect1448903affect
ainsell796393ainsell
anent54931843an_ent
aspect10612823aspect
assent65119953assent
assert64922573assert
asset55932263asse_t
basest84720493basest
beset76739133bese_t
bisects1137133bisects
coinfect15276843coinfect
confect143614273confect
connect113515743connect
consent93723113consent
convect143114483convect
cosec96320183cosec_
cosecs105015213cosecs
coset75748843cose_t
cusec94614903cusec_
cusecs10509153cusecs
defect124816173defect
deject164512843deject
densest83112473densest
desert72725493desert
detect94217403detect
dialect101210263dialect
direct93817333direct
disject17268673disject
disseat83816923disseat
dissects11279243dissects
dissent84018683dissent
dissert83720693dissert
effect1437443effect
eject145016043_eject
elect74327033_elect
enact73525363en_act
enserf9310763enserf
erect74129333_erect
expect1758903expect
exsects1655573exsects
exsert13414363exsert
finest94321733fin_est
ginseng933433ginseng
iciest82914743iciest
idlest74014863idlest
illest63615723illest
impact122310443impact
inanest72115363inanest
inapt73522693in_apt
inarch1139163inarch
incant82418503incant
incents92414533incents
incepts11238283incepts
incests92711383incests
inch95420823in__ch
incult82414773incult
indecent11411273indecent
indeed83913563indeed
indene73215373indene
indents83114663indents
index13310983inde_x
indicts103210723indicts
indirect1147513indirect
induce93811533induce
inducts10259573inducts
indult73614033indult
indwelt1146513indwelt
inerts64517023in_erts
inexact1647413inexact
infant92315133infant
infarct1249013infarct
infected14229403infected
infecter13229153infecter
infector13478843infector
infer84215033infe_r
infers93615443infers
infests10279793infests
inflects1336193inflects
inflict1248623inflict
infract12610003infract
ingesta8357863ingesta
ingests83210983ingests
ingot61221063in_got
inhere9313713inhere
inherit10312973inherit
injected18226753injected
injector17236923injector
inked104218523inke_d
inker94421093inke_r
inkers104018833inkers
inkiest113415043inkiest
inkjet1737453inkjet
inkpot1237813inkpot
inlace82513043inlace
inlets63915573inlets
inmesh1134853inmesh
inmost8411363inmost
inned64118423inne_d
inner54920623inne_r
inners63919343inners
input7314653in_put
inquest1638603inquest
ins35945603ins___
insane6314883insane
insanest8410343insanest
inseams9307903inseams
insectary1444203insectary
insectile1147103insectile
insecure1044653insecure
inserted92413053inserted
inserter82312133inserter
insetted9249023insetted
insetter8218593insetter
insheath14114413insheath
inside7613443inside
insight1137913insight
insists739083insists
insole63515863insole
insolent81311553insolent
insoul638463insoul
inspan837513inspan
inspected1445403inspected
inspector1344743inspector
instal6712183instal
instant7815343instant
instar6310013instar
instate71616473instate
instead836203instead
instep838193instep
insteps936573insteps
instil61111383instil
instinct1048723instinct
instruct1047543instruct
insults7268963insults
insure63416603insure
intend72310373intend
intents72115703intents
inter55028493inte_r
interact10316463interact
intercut10411113intercut
intern64016543intern
inters64328043inters
intersect11412113intersect
intort6418923intort
intreat7416303intreat
intuit6314083intuit
invected14258873invected
invents102812053invents
inverts103211953inverts
invests10319683invests
islet54527553i_slet
issei568573isse_i
isseis638563isseis
itself946253itself
kindest12311503kindest
knelt94617683kn_elt
linecut997983lin_ecut
liniest73321153liniest
linnet6419413linne_t
linseed838203linseed
linsey938983linse_y
linseys1035083linseys
mindset10313343mindse_t
minuet82621033minue_t
misact10316683misact
miseat82925703miseat
misseat93617233misseat
missent94318713missent
misset85028153misse_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
nisei54214353nise_i
niseis63512023niseis
noninsect1145493noninsect
object17135803object
obtect10129633obtect
oncet74626543once_t
onsets64013543onsets
pandect12310953pandect
piniest93121133piniest
pinkest132812623pinkest
prosect11313393prosect
refect114319333refect
reinfect1346483reinfect
reinject1745543reinject
reinsert8313213reinsert
reinspect1344293reinspect
reject154116283reject
reseat64131493reseat
resects94115593resects
resent63833623resent
reset55051863rese_t
respect11412033respect
ringent8315153ringent
rinse54820973rinse__
rinsed75016353rinse_d
rinser64317213rinse_r
rinsers73815743rinsers
rinses64720383rinse_s
roset55945243rose_t
seat47575563__seat
sec55945323__sec_
secs65033893__secs
sects75622893__sects
select82621173select
sent46963013__sent
sept65844363__sept
set36681253__se_t
sett45949053__sett
sext117338093__sext
sneck114713663sn_eck
subsect112611843subsect
sunset63723633sunse_t
suspect1158513suspect
tensest72713313tensest
tinct76126233tin__ct
tiniest73020123tiniest
tinsel639443tinse_l
tinsels738373tinsels
transect10410053transect
trisect939733trisect
twinset1039373twinse_t
unbelt83015693unbelt
unbent83216593unbent
unfelt92413463unfelt
unkent103116053unkent
unkept123710873unkept
unlet54133333unle_t
unmeet83815743unmeet
unmet74426393unme_t
unpent83117373unpent
unrent63219783unrent
unrest62918853unrest
unseal63315473unseal
unseam83313143unseam
unseats73012853unseats
unseen62012623unseen
unsell63512543unsell
unsets64116163unsets
unsew83912693unse_w
unsewn9298393unsewn
unsews9379363unsews
unsex123512633unse_x
unsexy16296903unsexy
unshut939013unshut
unspent92610893unspent
unswept1246013unswept
unvext1658173unvext
unwept11389813unwept
unwet84423173unwe_t
upsent83314063upsent
upset73222593upse_t
viniest103216613viniest
vivisect1643783vivisect
winiest103419693winiest
wisent93516343wisent
wisest95016443wisest

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 Filter1786911127160.186960704.3
2DLD Change Limit1127163108.65613021.7
3Display Results3103100.1102818.2
 (SQL Overall)1786913108.95219961.0
 
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.