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

230 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
pastured113823(None) 
pastored1139971pastored
pasture9311461pasture_
pasturer1037521pasturer
pastures10311961pastures
postured1139491postured
assured858372_assured
captured1336572captured
gestured1036992gestured
mastered112614002mastered
matured10310042ma_tured
natured838962na_tured
paltered113012492paltered
pasted94426902past__ed
pastural1038412pastural
pasturers1136392pasturers
pattered112714202pattered
pestered112814972pestered
pictured1346572pictured
plastered1288902plastered
posture9313252posture_
posturer1038922posturer
postures10313782postures
pustuled1134952pustuled
raptured1155472raptured
vestured1237462vestured
abjured1735083_abjured
adjured1634883_adjured
allured8299173_allured
altered83215743_altered
antired82316193_antired
apertured1244063apertured
ascared10399523_ascared
aspired1068173_aspired
assumed1065293_assumed
assure6610773_assure_
assureds984493_assureds
assurer767793_assurer
assures7611403_assures
astute6310763_astute_
attired8238913_attired
attuned835173_attuned
augured987193_augured
bantered113313633bantered
bartered113113013bartered
bastard103012423bastar_d
basted95227233bast__ed
battered113315053battered
bistered112913333bistered
bistred103311853bist_red
cantered113415983cantered
capture1138913capture_
capturer1246093capturer
captures1239443captures
casqued19235633casqu_ed
castled104311513cast_led
catered103117773ca_tered
clotured11246163clotured
costumed1365033costumed
cultured1137233cultured
dastard9279703dastar_d
dasyure1153823dasyure_
dasyures1254153dasyures
disturbed13195583disturbed
ensured83512943ens_ured
factored1436233factored
facture12108933facture_
factures13129033factures
faltered122810993faltered
fasted105320953fast__ed
fastened12257853fastened
favoured1533963favoured
featured1237683featured
festered122512113festered
fissured1235183fissured
fostered122210453fostered
fractured15125063fractured
gartered10319593gartered
gasted84821583gast__ed
gastrea847243gast_rea
gesture839243gesture_
gesturer935983gesturer
gestures9310013gestures
hachured1744393hachured
haltered123112563haltered
hasted105125283hast__ed
hastened12239103hastened
hatred104814333ha_t_red
insured83714253ins_ured
kashered1636403kashered
laboured1156333laboured
lasted74323603last__ed
lectured11127233lectured
lustered92510603lustered
lustred8359053lust_red
manured1039473ma_nured
martyred1434283martyred
masted94025803mast__ed
mattered112412903mattered
mature8313473ma_ture_
maturer938983ma_turer
matures9314313ma_tures
measured1136463meas_ured
mistuned1157723mistuned
mustered112511503mustered
nattered92011623nattered
nature6311263na_ture_
natures7311963na_tures
nurtured935253nurtured
obscured1343893obscured
oystered1236923oystered
pagurid11105443pa_gurid
paired95017523pa__ired
palterer102411283palterer
pampered15229233pampered
pandered121812573pandered
panted95024823pant__ed
pantiled113111593pantiled
papered122513173pa_pered
pared86946763pa___red
parred95024073pa__rred
parted94228683part__ed
partied103516553part_ied
partnered1244483partnered
parure8312523pa_rure_
parures9512693pa_rures
pashed125923143pas__hed
passaged1236243passaged
passed94320943pas__sed
passuses1036773passuses
paste74932953past__e_
pastel85918713past__el
paster85734373past__er
pastern94415063paster_n
pasterns104112623pasterns
pasters94531733paster_s
pastes85233913past__es
pasteurised1452603pasteurised
pasteurized2353113pasteurized
pastie85525523past_ie_
pastier94320383past_ier
pasties94529813past_ies
pastime114611973pastime_
pastimes123611903pastimes
pastises103616053pastises
pastor84817483pastor__
pastoral10310483pastoral
pastorly1345783pastorly
pastors94119003pastor_s
pastries101517423pastries
pastry114913033past_r_y
pasturage1244923pasturage
pasturages1344923pasturages
pastureland1451183pastureland
pasturing1238433pasturing
patched153514623pa_tched
pated85237843pa_t__ed
patined105114783pa_tined
patted94724683pa_t_ted
pattened11299393pattened
patterer103112173patterer
patterned1265743patterned
paupered13216943paupered
paused95114963pa__used
peltered112510453peltered
perdured12287403perdured
perjured18286273perjured
perturbed1443353perturbed
pesterer102412713pesterer
pestled102711453pest_led
petered103314973p_etered
piastre9307893piast_re_
piastres10249303piast_res
picture1158613picture_
pictures1249343pictures
pistoled11259593pistoled
plaistered1344133plaistered
plasterer1178113plasterer
pleasured1244193pleas_ured
portered112311543portered
posted93722493post__ed
postgrad1245493postgrad
postural1049203postural
posturers1137053posturers
pottered112311663pottered
poured95116743p__oured
preassured1344533preassured
precured1339993precured
pressured1237333pressured
prestored125111673prestored
procured1336603procured
punctured1444183punctured
pustule937683pustule_
pustules1038443pustules
puttered112611143puttered
raftered1237663raftered
rapture937393rapture_
raptures1037583raptures
rasure6311423ras_ure_
rasures7312013ras_ures
reassured1046103reassured
restored96417193restored
ruptured1144683ruptured
savoured1234793savoured
sistered92612803sistered
soured74921863__soured
spattered12187643spattered
stared75429873__stared
stored75524213__stored
sutured8310373_sutured
taboured1156273taboured
tasted74123973tast__ed
tattered92011443tattered
textured1695483textured
tortured935843tortured
unassured1084353unassured
unsoured9310063unsoured
upstared11156573upstared
vapoured1434353vapoured
ventured1238273ventured
vesture10310373vesture_
vestures11311043vestures
wafture1334853wafture_
waftures1434853waftures
waitered1238753waitered
wasted104423023wast__ed
wastrel1037553wast_rel
watered113014953wa_tered
westered122511873westered
yattered12239533yattered

Search took 8 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 Limit1461622306.76321612.0
3Display Results2302300.0932473.1
 (SQL Overall)1786912307.27924548.8
 
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.