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

139 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
pictured134657(None) 
picture1158611picture_
pictures1249341pictures
cinctured1444272cinctured
lectured11127222lectured
pastured1138232pastured
picturized2443682picturized
postured1139492postured
punctured1444182punctured
tinctured1243512tinctured
apertured1244063apertured
bickered17108003bickered
bioturbed1441713bioturbed
bistered112913323bistered
bistred103311853bist_red
bittered112711833bittered
captured1336573captured
cincture1245583cincture_
cinctures1346063cinctures
clotured11246163clotured
cultured1137233cultured
cured85932133__c_ured
dickered16117533dickered
dictated1239203dictated
disturbed13195583disturbed
doctored1245613doctored
epicure1136823epic_ure_
epicures1246513epic_ures
factored1436213factored
facture12108923facture_
factures13129023factures
featured1237683featured
figured12196473fi_gured
filtered12259043filtered
fissured1235183fissured
fixture1734963fixture_
fixtures1835283fixtures
fractured15125043fractured
gestured1036993gestured
hachured1744393hachured
hectored1436873hectored
hiccuped1861883hiccuped
ictuses938303_ictuses
immured1235063_immured
injured15339063_injured
insured83714253_insured
inturned9268313_inturned
inured73114813_i_nured
jittered16267223jittered
jointured17133483jointured
lecture9149513lecture_
lecturer10136023lecturer
lectures101310153lectures
ligatured1143333ligatured
littered92511383littered
matured10310033_matured
micturated1584993micturated
mistuned1157723mistuned
mitered103213233mi_tered
mitred94414343mi_t_red
mixture1635413mixture_
mixtures1735753mixtures
natured838963_natured
nickered15117023nickered
nictated1137793nictated
nurtured935253nurtured
paltered113012483paltered
pastored1139963pastored
pasture9311463pasture_
pasturer1037523pasturer
pastures10311963pastures
pattered112714203pattered
pectized22257593pectized
pedicured1543593pedic_ured
peltered112510453peltered
perdured12287403perdured
perjured18286273perjured
perturbed1443353perturbed
pestered112814963pestered
petered103314973p_etered
philtered1545493philtered
philtred14114183philt_red
pickaxed2443513pickaxed
picked154421313pic__ked
pickeered1843463pickeered
pickerel1645273pickerel
picketed17167383picketed
pickled164011883pic_kled
picoted1239213pic_oted
picquet2047743picqu_et
picrated132110113picrated
picturing1436033picturing
picturize2244463picturize
picturizes2344563picturizes
pilfered1435853pilfered
pillared11228093pillared
piqued1836213pi_qu_ed
pistoled11259593pistoled
pitched153512923pi_tched
pithed124615613pi_t_hed
pitied94017253pi_t_ied
pitted94319593pi_t_ted
plicature1344023plicature_
plicatures1443983plicatures
portered112311543portered
posture9313253posture_
posturer1038923posturer
postures10313783postures
pottered112311663pottered
poured95116743p__oured
precured1339993precured
proctored1446413proctored
procured1336603procured
puckered1736103puckered
puncture1245053puncture_
punctures1345343punctures
pustuled1134953pustuled
puttered112611143puttered
raptured1155463raptured
rictuses1037563rictuses
ruptured1144683ruptured
scoured103811153_scoured
sectored1138063sectored
secured1059723sec_ured
sintered92213903sintered
sistered92612803sistered
sutured8310373_sutured
textured1695483textured
tincture1044673tincture_
tinctures1144923tinctures
tittered9239493tittered
tittuped1142063tittuped
tortured935843tortured
uncured10513233unc_ured
vectored1435623vectored
ventured1238273ventured
vestured1237463vestured
victualed1543103victualed
wintered122111573wintered

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.423422437.4
2DLD Change Limit1461621397.57619292.8
3Display Results1391390.0632206.3
 (SQL Overall)1786911398.06222164.6
 
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.