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

309 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
pasture931146(None) 
pastured1138231pastured
pasturer1037521pasturer
pastures10311961pastures
posture9313251posture
assure6610772_assure
astute6310762_astute
capture1138912capture
dasyure1153822dasyure
facture12108942facture
gesture839242gesture
mature8313472ma_ture
nature6311262na_ture
parure8312522pa_rure
paste74932952past__e
paster85734372paster_
pastern94415062pastern
pasters94531732pasters
pastie85525522past_ie
pastier94320382pastier
pastime114611972pastime
pastor84817482pastor_
pastored1139972pastored
pastors94119002pastors
pastry114913032past_ry
pasturage1244922pasturage
pastural1038412pastural
pasturers1136392pasturers
piastre9307892piast_re
picture1158612picture
postured1139492postured
posturer1038922posturer
postures10313782postures
pustule937682pustule
rapture937392rapture
rasure6311422ras_ure
vesture10310372vesture
wafture1334852wafture
abjure1536743_abjure
adjure1435843_adjure
allure63012943_allure
antre55224523_ant_re
aperture1046393aperture
armure8710133_armure
ashore9414613_ashore
aspire8612123_aspire
assume897563_assume
assured858373_assured
assurer767793_assurer
assures7611403_assures
aster55434893_aster_
astern64815813_astern
asters65631603_asters
astir55517093_astir_
attire62412383_attire
attune637983_attune
austere7312993austere
azure14911483_a_zure
bascule1136573bascule
basque17259083basqu_e
bastard103012423bastard
baste74829983bast__e
baster85333603baster_
basters94930313basters
bastile9313913bastile
battue84311003battu_e
bistre83815023bist_re
captured1336573captured
capturer1246103capturer
captures1239443captures
casque17299273casqu_e
caste75932363cast__e
caster85232573caster_
casters94729903casters
castle84918963cast_le
castor84418533castor_
castors94919443castors
cloture9238453cloture
costume1157853costume
couture9310623couture
culture939393culture
dastard9279703dastard
dasyures1254153dasyures
datura738043da_tura
denture8311893denture
departure1243803departure
disturb1046233disturb
easter65027983easter_
eastern74412533eastern
easters75125683easters
ensure63416003ens_ure
erasure736943eras_ure
factures13129043factures
failure1035753failure
faster94625773faster_
feature1039853feature
fissure1036783fissure
fixture1734963fixture
fracture13147143fracture
future939563_future
gaster75027353gaster_
gasters85624303gasters
gastrea847253gast_rea
gestured1036993gestured
gesturer935983gesturer
gestures9310013gestures
hachure1545723hachure
haltere103614713haltere
hastate10313913hastate
haste85927863hast__e
hastier103916623hastier
imposture1343663imposture
insure63416603ins_ure
katsura1143763katsura
laster64830633laster_
lasters75627693lasters
lecture9149523lecture
lustre64011683lust_re
manure8313653ma_nure
masque17249383masqu_e
masquer18266463masquer
master84831343master_
mastered112614013mastered
masters94628923masters
mastery124214323mastery
matured10310043ma_tured
maturer938983ma_turer
matures9314313ma_tures
measure939033meas_ure
mistune9310653mistune
mixture1635413mixture
moisture1046653moisture
multure939183multure
nastier74115293nastier
natured838963na_tured
natures7311963na_tures
nurture736643nurture
obscure1145333obscure
ossature843303ossature
padre86018163pa__dre
palter84423263palter_
paltered113012503paltered
palterer102411293palterer
palters94021683palters
paltry114910403palt_ry
pandore10411853pandore
pandura1037143pandura
panther12611443panther
pantie84326473pant_ie
pantile93918483pantile
pantry115014103pant_ry
papule102212133pa_pule
pare66760843pa___re
partake1339643partake
parterre1037013parterre
partier93520713partier
partite9317133partite
partner92811393partner
partyer12337873partyer
parura8310593pa_rura
parures9512693pa_rures
pase65346863pas___e
pasquil1843923pasquil
passade1039233passade
passage1039803passage
passe75525693pas__se
passee84522023pas_see
passer84721033passer_
passers94717753passers
passive12239593passive
passus83610293passu_s
passuses1036773passuses
past65959013past___
pasta76624533past__a
pastas85422873past_as
pasted94426903past_ed
pastel85918713past_el
pastels95215183pastels
pasterns104112623pasterns
pastes85233913past_es
pasteup1134983pasteup
pasteups1243493pasteups
pasteurise1244123pasteurise
pasteurize2143663pasteurize
pastiche1546933pastiche
pasties94529813pasties
pastil85018323past_il
pastille1038943pastille
pastils94416173pastils
pastimes123611903pastimes
pastina93914593pastina
pasting103826553pasting
pastis84924323past_is
pastises103616053pastises
pastoral10310483pastoral
pastorale1147323pastorale
pastorate11411183pastorate
pastorly1345783pastorly
pastries101517423pastries
pasts75936503past__s
pasturages1344923pasturages
pasturing1238433pasturing
pasty105725053past__y
pate65350463pa_t__e
pater74740733pa_ter_
paters84935843pa_ters
patine85328123pa_tine
pattee84323383pa_ttee
patter84628263patter_
pattered112714213pattered
patterer103112183patterer
pattern93712053pattern
patters94825193patters
pattie84020963pa_ttie
patzer173111643pa_tzer
pause75021833pa__use
perdure10379623perdure
perjure16327963perjure
perturb1146003perturb
pester84827593pester_
pestered112814973pestered
pesterer102412713pesterer
pesters93827093pesters
pestier94317403pestier
pestle83215843pest_le
piaster93012883piaster_
piasters102912813piasters
piastres10249303piast_res
pictured1346573pictured
pictures1249343pictures
pismire1135353pismire
piste75824603pist__e
pistole92414313pistole
plaster93318693plaster_
plastered1288913plastered
plasterer1178113plasterer
plasters103518133plasters
plastery13279703plastery
plastrum1245713plastrum
pleasure1045543pleas_ure
poseur8419403poseur_
poseurs9378303poseurs
postage103214853postage
postburn1243923postburn
poster84129173poster_
postern93615613postern
posters93928013posters
postfire1346273postfire
postie84123963post_ie
postlude1144543postlude
postural1049203postural
posturers1137053posturers
preassure1145623preassure
precure11312553precure
pressure1039773pressure
prestore104217353prestore
procure1138573procure
puncture1245053puncture
pure65543333p___ure
purpure1195993purpure
pustuled1134953pustuled
pustules1038443pustules
raptured1155473raptured
raptures1037583raptures
raster64731443raster_
rasters74629023rasters
rasures7312013ras_ures
reassure847343reassure
restore75822983restore
rupture966163rupture
saltire73113043saltire
santur6311273santur_
santurs7310763santurs
satire63218003sa_tire
stare54440263__stare
stature74410683stature
stere55328543__stere
store56333813__store
stoure64814943__stoure
stupe75217753__stupe
sturt56028963__sturt
sure45447413__s_ure
suture6313203_suture
tartare73012683tartare
tartufe1064673tartufe
taste55127233tast__e
taster64930573taster_
tasters74225643tasters
tastier711817093tastier
texture1497083texture
torture738593torture
unsure62815413uns_ure
upstare9158683upstare
vaster94521023vaster_
vastier103613203vastier
venture10311173venture
vestured1237463vestured
vestures11311043vestures
vulture1036763vulture
waftures1434853waftures
wastage11109253wastage
waste86125053wast__e
waster95228943waster_
wasterie111211593wasterie
wasters104026593wasters
wastery134610993wastery
wastrel1037553wast_rel
wastrie101210303wastrie
wastry12388773wast_ry

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 Filter1786911340270.436409841.7
2DLD Change Limit1340273097.70317399.3
3Display Results3093090.1262452.4
 (SQL Overall)1786913098.26521620.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.