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

149 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
pasturers113639(None) 
pasturer1037521pasturer_
pastures10311961pasture_s
posturers1137051posturers
assurers866312_assurers
capturers1344632capturers
gesturers1044282gesturers
maturers1037372ma_turers
palterers11249532palterers
pasters94531732past__ers
pasture9311462pasture__
pastured1138232pasture_d
patterers112410122patterers
pesterers112510452pesterers
plasterers1286122plasterers
posturer1038922posturer_
postures10313782posture_s
abjurers1733943_abjurers
adjurers1634373_adjurers
allurers8286773_allurers
alterers82512493_alterers
aspirers1066493_aspirers
assumers1064963_assumers
assureds984493_assureds
assurer767793_assurer_
assures7611403_assure_s
assurors894043_assurors
asters65631603_ast__ers
augurers9114813_augurers
banterers112410003banterers
barterers11269633barterers
basters94930303bast__ers
batterers113110713batterers
capturer1246093capturer_
captures1239443capture_s
casters94729903cast__ers
caterers102814403ca_terers
costumers1374853costumers
dasyures1254153dasyure_s
disturbers13164163disturbers
easterners1044823easterners
easters75125683east__ers
ensurers8279373ens_urers
factures13129023facture_s
falterers12238033falterers
fasteners12237053fasteners
favourers1543123favourers
fosterers12238023fosterers
fracturers15123203fracturers
gasters85624293gast__ers
gastreas957253gast_reas
gesturer935983gesturer_
gestures9310013gesture_s
hasteners12267813hasteners
insurers83710133ins_urers
labourers1144713labourers
lasters75627693last__ers
lecturers11124233lecturers
manurers1037593ma_nurers
masquers19195703masqu_ers
masters94628923mast__ers
maturer938973ma_turer_
matures9314303ma_ture_s
measurers1144883meas_urers
natures7311963na_ture_s
nurturers943353nurturers
oysterers1245573oysterers
palterer102411273palterer_
palters94021683palt__ers
pamperers15236863pamperers
panderers12229153panderers
pantdress1243363pantdress
panthers13510783pant_hers
paperers122410453pa_perers
parers85530743pa___rers
partakers1536563partakers
parterres1148053parterres
partiers103514243part_iers
partners102711133part_ners
partyers13277763part_yers
parures9512693pa_rure_s
passers94717753pas__sers
passovers14144753passovers
passuses1036773passuse_s
pastels95215183past__els
paster85734373past__er_
pastern94415063past__ern
pasterns104112623paster_ns
pastes85233913past__e_s
pasteurizers2351763pasteurizers
pastier94320383past_ier_
pasties94529813past_ie_s
pastimes123611903pastime_s
pastiness112312353pastiness
pastises103616053pastise_s
pastless102411203past_less
pastness102510503past_ness
pastorals1147953pastorals
pastored1139963pastore_d
pastors94119003past__ors
pastries101517423past_ries
pasturage1244923pasturage
pasturages1344923pasturages
pastural1038413pastur_al
pasturing1238433pasturing
patchers153413303pa_tchers
paters84935833pa_t__ers
patterer103112173patterer_
patters94825193pa_t_ters
patzers184210573pa_t_zers
paupers114311073pa__upers
pausers94113223pa__users
peasoupers1492053peasoupers
perjurers18224463perjurers
perturbers1442633perturbers
pesterer102412703pesterer_
pesters93827093pest__ers
pewterers14216043pewterers
piasters102912813piast__ers
piastres10249303piast_re_s
pictures1249343picture_s
plasterer1178103plasterer_
plasters103518133plast__ers
posters93928013post__ers
posture9313253posture__
postured1139493posture_d
potterers11218663potterers
pourers93513673p__ourers
procurers1345033procurers
pustules1038443pustule_s
putterers11238363putterers
raptures1037573rapture_s
rasters74629023rast__ers
rasures7312013ras_ure_s
restorers95110113restorers
savourers1243833savourers
starers74522313__starers
storers75018683__storers
tabourers1144673tabourers
tasters74225643tast__ers
torturers944343torturers
usurers766363_us_urers
vapourers1443373vapourers
venturers1245523venturers
vestures11311043vesture_s
waftures1434853wafture_s
wasters104026593wast__ers
wastrels1136203wast_rels
waterers112312783wa_terers

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411496.64022385.7
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.12625075.9
 
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.