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 “lectures” 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
lectures10131015(None) 
lecture9149511lecture_
lectured11127221lectured
lecturer10136021lecturer
lecturers11124231lecturers
dentures9312452dentures
factures13129022factures
features11310332features
gestures9310012gestures
hectares1338852hectares
lecterns1035942lecterns
lectors93415762lector_s
leisures836682leisures
lemures938792le_mures
lettuces1043502lettuces
pictures1249342pictures
secures9613162sec_ures
textures1597522textures
ventures11311492ventures
vestures11311042vestures
apertures1146473apertures
arcatures1186833arcatures
becurse1136183bec_urse
becurses1236723bec_urses
cactuses1237933cactuses
calentures1244603calentures
captures1239443captures
ceintures1136733ceintures
censures102211623censures
centares102913893centares
centres93817123cent_res
centuries11311333centuries
cestuses1038083cestuses
cinctures1346063cinctures
clotures10299023clotures
coutures10311993coutures
creatures1138413creatures
cultures10310153cultures
cures75645433__c_ures
decares102818533dec_ares
deciares11510633deciares
declares11611313declares
decuries11312223dec_uries
decurves1435863dec_urves
denatures1038123denatures
denture8311893denture_
ductules1155543ductules
ectases92911673_ectases
ectypes1434803_ectypes
electees10238723elect_ees
electives1448923electives
electors103013843elector_s
electress1146113elect_ress
electret10411993elect_ret
electrets1146543elect_rets
electros102811743elect_ros
electrums1344483electrums
electuaries1354233electuaries
endures83314603_endures
ensures73315903_ensures
entires71517783_entires
enures63919713_e_nures
etudes73811603_e_tudes
facture12108923facture_
feature1039853feature_
featured1237683featured
fetuses10310243fe_tuses
fixtures1835283fixtures
flexures1843423fle_xures
fractures14147233fractures
futures10310263_futures
genitures1046123genitures
gesture839243gesture_
gestured1036993gestured
gesturer935983gesturer
gesturers1044283gesturers
hachures1645873hachures
hectare1238463hectare_
hectored1436873hectored
hectors123513263hector_s
hektares1535813hektares
ictuses938303_ictuses
junctures1844033junctures
lacquers19125033lacquers
lactases1038513lactases
lactates10311223lactates
lactones10311223lactones
lactoses1039813lactoses
lacunes9159623lac_unes
leaguers935063leaguers
leagues837943leagu_es
leathers114215083leathers
lechered1437523lechered
lecheries1449073lecheries
lechers123313963lecher_s
leches115421313lec__hes
lechwes1535063lec_hwes
lectern937033lecter_n
lectins92515003lect_ins
lections102413843lections
lector83514983lector__
lectureship1861983lectureship
lecturing1237303lecturing
lefties10312073left_ies
legumes1036633le_gumes
leisure736693leisure_
leisured934763leisured
lemurs837253le_mur_s
leotards945303leotards
letches124015483le_tches
lethes94818083le_t_hes
lettered92910783lettered
letterer8259223letterer
letterers9228113letterers
letters73819853letter_s
lettuce943323lettuce_
letups8317683le_tu_ps
leudes75314093le__udes
levatores12225733levatores
lictors93212593lictor_s
ligatures1044933ligatures
ligures8269893l_igures
litres65220393l_it_res
locules92812603loc_ules
lotuses74011253l_otuses
lucres84513303luc__res
lures56138533l___ures
lustres73013233lust_res
matures9314303_matures
measures1038913measures
meatuses1038203meatuses
metres85121563me_t_res
mixtures1735753mixtures
multures1039333multures
natures7311963_natures
nectaries1149813nectaries
nectars938463nectar_s
nervures1135123nervures
noctules1036583noctules
nocturnes1143853nocturnes
nocturns1043733nocturns
nurtures837443nurtures
overtures121611453overtures
pastures10311963pastures
pectases122411193pectases
pectates122213953pectates
pectines121914683pectines
pectizes21229783pectizes
perdures11289683perdures
perjures17268083perjures
perturbs1244363perturbs
picture1158613picture_
pictured1346573pictured
pleasures1145573pleasures
plectrums1553033plectrums
plicatures1443983plicatures
postures10313783postures
precures12312903prec_ures
punctures1345343punctures
raptures1037573raptures
recaptures1474463recaptures
recluses105111733recluses
recourse1038383recourse
recourses1137733recourses
rectories11314643rectories
rectors93520513rector_s
rectums11338523rectu_ms
rectus83314633rectu__s
recurs83315803rec_ur_s
recurves1337403rec_urves
recuses94619463rec_uses
renatures939443renatures
restores85222993restores
retires74726213re_tires
retunes76918403re_tunes
returns79712593re_turns
rictuses1037563rictuses
ruptures1056683ruptures
secludes1134953secludes
sectaries11312243sectaries
sectored1138063sectored
sectors93116443sector_s
secure8513533sec_ure_
secured1059723sec_ured
securer958253sec_urer
securers1057153sec_urers
securest1058583sec_urest
seisures838273seisures
seizures1744633seizures
spectres12268683spect_res
statures83711113statures
sutures7314223_sutures
tectites1039993tectites
tectums11306423tectu_ms
tenures7412013te_nures
texture1497083texture_
textured1695483textured
tinctures1144923tinctures
tortures838913tortures
vectored1435623vectored
vectors123212593vector_s
velures1039093ve_lures
venture10311173venture_
ventured1238273ventured
venturer1137243venturer
venturers1245523venturers
venturis1138193venturis
verdures12247753verdures
vesture10310373vesture_
vestured1237463vestured
vultures1137213vultures
waftures1434853waftures

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622126.48622535.0
3Display Results2122120.0902355.6
 (SQL Overall)1786912126.73226543.5
 
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.