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

154 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
lectured1112722(None) 
lecture9149511lecture_
lecturer10136021lecturer
lectures101310151lectures
featured1237682featured
gestured1036992gestured
hectored1436872hectored
lechered1437522lechered
lecturers11124232lecturers
leisured934762leisured
lettered92910782lettered
pictured1346572pictured
sectored1138062sectored
secured1059722sec_ured
textured1695482textured
vectored1435622vectored
ventured1238272ventured
vestured1237462vestured
apertured1244063apertured
becursed1335583bec_ursed
bescoured1444333bescoured
bettered113011833bettered
captured1336573captured
censured11248913censured
centered112513523centered
centred103411683cent_red
cinctured1444273cinctured
clotured11246163clotured
cultured1137233cultured
cured85932133__c_ured
declared1248743declared
decurved1534843dec_urved
denatured1146023denatured
denture8311893denture_
dentures9312453dentures
detoured1036513detoured
devoured1335723devoured
doctored1245613doctored
elected102812613elect__ed
electret10411993elect_ret
electroed1246973electroed
endured93611213_endured
ensured83512943_ensured
entered82718883_entered
enured73315333_e_nured
factored1436213factored
facture12108923facture_
factures13129023factures
feature1039853feature_
features11310333features
festered122512103festered
fettered12259493fettered
fractured15125043fractured
gesture839243gesture_
gesturer935983gesturer
gestures9310013gestures
gettered10258613gettered
hachured1744393hachured
hectare1238463hectare_
hectares1338853hectares
laboured1156323laboured
lackered15108673lackered
lacquered2143363lacquered
lactated1138863lactated
leagued935463leagu_ed
leaguered1143223leaguered
leathered13148713leathered
leched123716003lec__hed
lectern937033lecter_n
lecterns1035943lecterns
lector83514983lector__
lectors93415763lector_s
lecturing1237303lecturing
leered73816223le__ered
leistered1037043leistered
leisure736693leisure_
leisures836683leisures
lemures938793le_mures
leotard846193leotar_d
leotarded1142783leotarded
letched133912053le_tched
letted74118543le_t_ted
letterer8259223letterer
lettuce943323lettuce_
lettuces1043503lettuces
levered114212303le_vered
ligatured1143333ligatured
littered92511383littered
loculed10317653loc_uled
loitered938183loitered
loured74617403l__oured
lured65427493l___ured
lustered92510603lustered
lustred8359053lust_red
matured10310033_matured
measured1136463measured
mentored1138003mentored
metered103514013me_tered
metred95315143me_t_red
natured838963_natured
nectaried1245443nectaried
neutered937423neutered
nurtured935253nurtured
overtured13169213overtured
pastured1138233pastured
pectized22257593pectized
peltered112510453peltered
perdured12287403perdured
perjured18286273perjured
perturbed1443353perturbed
pestered112814963pestered
petered103314973pe_tered
picture1158613picture_
pictures1249343pictures
pleasured1244193pleasured
postured1139493postured
precured1339993prec_ured
punctured1444183punctured
raptured1155463raptured
recaptured1573593recaptured
recouped13128663recouped
recurred1137093recurred
recurved1436493rec_urved
recused104714423rec_used
renatured1047283renatured
repoured1139563repoured
restored96417193restored
retired84620143re_tired
retuned86613973re_tuned
returned9459133re_turned
ruptured1144683ruptured
scoured103811153_scoured
secluded1233663secluded
secure8513533sec_ure_
securer958253sec_urer
secures9613163sec_ures
sutured8310373_sutured
teetered9258303teetered
tentered96412103tentered
tenured838363te_nured
texture1497083texture_
textures1597523textures
tinctured1243513tinctured
tortured935843tortured
uncured10513233unc_ured
velured1136683ve_lured
venture10311173venture_
venturer1137243venturer
ventures11311493ventures
verdured13255763verdured
vesture10310373vesture_
vestures11311043vestures
weltered12238433weltered
westered122511863westered

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621547.53319402.9
3Display Results1541540.0602566.7
 (SQL Overall)1786911547.99922339.2
 
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.