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

212 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
lecture914952(None) 
lectured11127231lectured
lecturer10136031lecturer
lectures101310161lectures
denture8311892denture
facture12108942facture
feature1039852feature
gesture839242gesture
hectare1238472hectare
lectern937032lectern
lector83514992lector_
lectors93415772lectors
lecturers11124232lecturers
leisure736692leisure
lettuce943322lettuce
picture1158612picture
secure8513532sec_ure
texture1497082texture
venture10311172venture
vesture10310372vesture
aperture1046393aperture
arcature1086503arcature
because1136233because
becurse1136183bec_urse
calenture1144313calenture
capture1138913capture
ceinture1036313ceinture
censure92310603censure
centare93113703centare
centre84316643cent_re
century1237193century
cincture1245583cincture
cloture9238453cloture
couture9310623couture
creature1038743creature
culture939393culture
cure66149123__c_ure
decare93919153dec_are
deciare10710663deciare
declare10411233declare
decurve1335583dec_urve
decury1277963dec_ury
demure9311533de_mure
denature938073denature
dentures9312453dentures
ductule1065503ductule
ectype1334283_ectype
electee92513243elect_ee
elective13311003elective
elector93313263elector_
electors103013863electors
electret10412003elect_ret
electro92810033elect_ro
electrum1245213electrum
electuary1443273electuary
endure74014143_endure
ensure63416003_ensure
entire61617703_entire
enure53520223_e_nure
etude63612303_e_tude
factures13129043factures
featured1237683featured
features11310333features
fixture1734963fixture
flexure1743413fle_xure
fracture13147143fracture
future939563_future
geniture946453geniture
gestured1036993gestured
gesturer935983gesturer
gestures9310013gestures
hachure1545723hachure
hectares1338863hectares
hector113312653hector_
hectored1436893hectored
hectors123513263hectors
hektare1435513hektare
juncture1743903juncture
lacquer18135153lacquer
lactary1237853lactary
lactase937963lactase
lactate9312703lactate
lactone9311413lactone
lactose969493lactose
lacune8169673lac_une
league758743leagu_e
leaguer835793leaguer
leather103815783leather
lecher113415853lecher_
lechered1437523lechered
lechers123313963lechers
lechery15257643lechery
lechwe1435113lec_hwe
lecterns1035943lecterns
lectin82515013lect_in
lectins92515003lectins
lection92614863lection
lecturing1237303lecturing
lefter93613433lefter_
legume936913le_gume
leisured934763leisured
leisures836683leisures
lemur739773le_mur_
lemures938793le_mures
lemurs837253le_murs
leotard846193leotard
lethe85717303le_t_he
letter63722583letter_
lettered92910783lettered
letterer8259223letterer
letters73819853letters
lettuces1043503lettuces
letup73712163le_tu_p
letups8317683le_tups
lictor83610863lictor_
lictors93212603lictors
ligature945133ligature
ligure7279473l_igure
litre55421463l_it_re
locule83412033loc_ule
lucre76415523luc__re
lure45142463l___ure
lustre64011683lust_re
mature8313473_mature
measure939033measure
metre74821303me_t_re
mixture1635413mixture
multure939183multure
nature6311263_nature
nectar838853nectar_
nectars938463nectars
nectary1246223nectary
nervure1034973nervure
noctule936083noctule
nocturn944653nocturn
nocturne1043393nocturne
nurture736643nurture
overture111511683overture
pasture9311463pasture
pectase112410363pectase
pectate112214693pectate
pectize20259913pectize
perdure10379623perdure
perjure16327963perjure
perturb1146003perturb
pictured1346573pictured
pictures1249343pictures
pleasure1045543pleasure
plectra1145793plect_ra
plectrum1453953plectrum
plicature1344023plicature
posture9313253posture
precure11312553prec_ure
puncture1245053puncture
rapture937393rapture
recapture1384713recapture
recluse95210773recluse
recoupe11109933recoupe
recourse1038383recourse
rector84019753rector_
rectors93520523rectors
rectory123512733rectory
rectum103411283rectu_m
rectums11338523rectums
rectus83314633rectu_s
recur74116843rec_ur_
recurs83315803rec_urs
recurve1237403rec_urve
recuse85519163rec_use
renature839333renature
restore75822983restore
retire64927013re_tire
retore67630773re_tore
retune69121953re_tune
return623222523re_turn
retuse66617223re_tuse
rupture966163rupture
seclude1035233seclude
sectary1238273sectary
sectile9311973sectile
sector83415933sector_
sectored1138083sectored
sectors93116453sectors
secured1059723sec_ured
securer958253sec_urer
secures9613163sec_ures
seisure738193seisure
seizure1634683seizure
spectre11297773spect_re
stature74410683stature
suture6313203_suture
tectite9310583tectite
tectum10328603tectu_m
tectums11306423tectums
tenure6311613te_nure
textured1695483textured
textures1597523textures
tincture1044673tincture
torture738593torture
vector113212063vector_
vectored1435643vectored
vectors123212593vectors
velure939773ve_lure
ventured1238273ventured
venturer1137243venturer
ventures11311493ventures
venturi1037203venturi
verdure11287773verdure
vestured1237463vestured
vestures11311043vestures
vulture1036763vulture
wafture1334853wafture

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272126.25021444.3
3Display Results2122120.0802650.0
 (SQL Overall)1786912126.75026472.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.