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

289 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
pastures1031196(None) 
pasture9311461pasture_
pastured1138231pastured
pasturer1037521pasturer
pasturers1136391pasturers
postures10313781postures
assures7611402_assures
captures1239442captures
dasyures1254152dasyures
factures13129022factures
gestures9310012gestures
matures9314302ma_tures
natures7311962na_tures
parures9512692pa_rures
passuses1036772passuses
pasterns104112622pasterns
pasters94531732paster_s
pastes85233912past__es
pasties94529812past_ies
pastimes123611902pastimes
pastises103616052pastises
pastored1139962pastored
pastors94119002pastor_s
pastries101517422pastries
pasturages1344922pasturages
pastural1038412pastural
piastres10249302piast_res
pictures1249342pictures
posture9313252posture_
postured1139492postured
posturer1038922posturer
posturers1137052posturers
pustules1038442pustules
raptures1037572raptures
rasures7312012ras_ures
vestures11311042vestures
waftures1434852waftures
abjures1636523_abjures
adjures1536233_adjures
allures72913113_allures
antres65021003_ant_res
apertures1146473apertures
armures9510273_armures
aspires9612043_aspires
assumes967163_assumes
assure6610773_assure_
assured858373_assured
assureds984493_assureds
assurer767793_assurer
assurers866313_assurers
asters65631603_aster_s
astute6310763_astute_
attires72312953_attires
attunes737823_attunes
aures55137093_a__ures
azures15510183_a_zures
bascules1236683bascules
basques18248673basqu_es
bastards113310313bastards
basters94930303baster_s
bastes85330383bast__es
bastiles10313353bastiles
battues94610193battu_es
bistres94017213bist_res
cactuses1237933cactuses
caestuses1144893caestuses
capture1138913capture_
captured1336573captured
capturer1246093capturer
capturers1344633capturers
casques18278983casqu_es
casters94729903caster_s
castes85631863cast__es
castles94917733cast_les
castors94919443castor_s
cestuses1038083cestuses
cistuses1038283cistuses
clotures10299023clotures
costumes1258013costumes
coutures10311993coutures
cultures10310153cultures
dastards10278083dastards
dasyure1153823dasyure_
daturas838773da_turas
dentures9312453dentures
departures1343533departures
disturbs1145403disturbs
easters75125683easter_s
ensures73315903ens_ures
erasures837213eras_ures
facture12108923facture_
failures1135163failures
fastuous1145143fastuous
features11310333features
fissures1136573fissures
fixtures1835283fixtures
fractures14147233fractures
futures10310263_futures
gasters85624293gaster_s
gastrea847223gast_rea
gastreas957253gast_reas
gesture839243gesture_
gestured1036993gestured
gesturer935983gesturer
gesturers1044283gesturers
hachures1645873hachures
halteres113414593halteres
hastes95727073hast__es
impostures1443803impostures
insures73117263ins_ures
katsuras1243653katsuras
lasters75627693laster_s
lectures101310153lectures
lustres73013233lust_res
manures9313353ma_nures
masquers19195703masquers
masques18239363masqu_es
mastered112614003mastered
masteries111018493masteries
masters94628923master_s
mastixes1738253mastixes
matres84522233ma_t_res
mature8313463ma_ture_
matured10310033ma_tured
maturer938973ma_turer
maturers1037373ma_turers
maturest1039693ma_turest
measures1038913meas_ures
mistunes10311133mistunes
mixtures1735753mixtures
moistures1147323moistures
multures1039333multures
nasties73520493nast_ies
nature6311263na_ture_
natured838963na_tured
nurtures837443nurtures
obscures1245513obscures
ossatures943423ossatures
padres95016983pa__dres
paltered113012483paltered
palterer102411273palterer
palterers11249533palterers
palters94021683palter_s
pandores11312453pandores
panduras1136953panduras
pantdress1243363pantdress
panthers13510783panthers
panties94230933pant_ies
pantiles103617153pantiles
pantries101817393pantries
papules112411573pa_pules
pares77164483pa___res
partakes1449923partakes
parterres1148053parterres
partiers103514243partiers
parties93230863part_ies
partners102711133partners
partyers13277763partyers
paruras9310533pa_ruras
parure8312523pa_rure_
pases75346503pas___es
pashes115828393pas__hes
pasquils1943123pasquils
passades1139203passades
passages1139513passages
passers94717753passer_s
passes86030473pas__ses
passives13228823passives
passus83610293passu__s
pastas85422873past__as
paste74932953past__e_
pasted94426903past__ed
pastel85918713past__el
pastels95215183past_els
paster85734373past__er
pastern94415063paster_n
pasteups1243493pasteups
pasteurise1244103pasteurise
pasteurises1343953pasteurises
pasteurizes2243663pasteurizes
pastiches1637453pastiches
pastie85525523past_ie_
pastier94320383past_ier
pastiest103319543past_iest
pastilles1148703pastilles
pastils94416173past_ils
pastime114611973pastime_
pastinas103712153pastinas
pastiness112312353pastiness
pastis84924323past__is
pastless102411203pastless
pastness102510503pastness
pastor84817483pastor__
pastoral10310483pastoral
pastorales1247133pastorales
pastorals1147953pastorals
pastorates12410143pastorates
pastorly1345783pastorly
pastry114913033past_r_y
pasts75936503past___s
pasturage1244923pasturage
pasturing1238433pasturing
patches143320383pa_tches
paters84935833pa_ter_s
pates76047893pa_t__es
patines95225763pa_tines
patsies93919483pa_tsies
pattered112714203pattered
patterer103112173patterer
patterers112410123patterers
patterns10439943patterns
patters94825193patter_s
patties93425143pa_tties
patzers184210573pa_tzers
pauses84621473pa__uses
perdures11289683perdures
perjures17268083perjures
perturbs1244363perturbs
pestered112814953pestered
pesterer102412703pesterer
pesterers112510453pesterers
pesters93827093pester_s
pestles93217693pest_les
piasters102912813piaster_s
piastre9307893piast_re_
picture1158613picture_
pictured1346573pictured
pismires1235883pismires
pistes85325633pist__es
pistoles102514723pistoles
plastered1288893plastered
plasterer1178103plasterer
plasterers1286123plasterers
plasters103518133plaster_s
plastrums1344513plastrums
pleasures1145573pleas_ures
poseurs9378293poseur_s
postages112815323postages
posterns102713723posterns
posters93928013poster_s
posties93128813post_ies
postludes1244623postludes
postural1049203postural
posturist11410443posturist
preassures1245273preassures
precures12312903precures
pressures1149063pressures
prestores114716083prestores
procures1239213procures
punctures1345343punctures
purpures1276143purpures
pustule937683pustule_
pustuled1134953pustuled
rapture937383rapture_
raptured1155463raptured
rasters74629023raster_s
rasure6311423ras_ure_
reassures937223reassures
restores85222993restores
ruptures1056683ruptures
saltires83112423saltires
santurs7310763santur_s
satires72617573sa_tires
stares66038753__stares
statures83711113statures
steres63929533__steres
stores65533663__stores
stoures74614163__stoures
stupes84116953__stupes
sturts63915143__sturts
sutures7314223_sutures
tartufes1164153tartufes
tasters74225643taster_s
tastes64126423tast__es
textures1597523textures
tortures838913tortures
upstares10178583upstares
ventures11311493ventures
vesture10310373vesture_
vestured1237463vestured
vultures1137213vultures
wafture1334853wafture_
wastages12109753wastages
wasteries121115343wasteries
wasters104026593waster_s
wastes96224883wast__es
wastrel1037553wast_rel
wastrels1136203wast_rels
wastries111212883wastries

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.1531167915.0
2DLD Change Limit1461622897.12620511.1
3Display Results2892890.1262293.7
 (SQL Overall)1786912897.40524131.1
 
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.