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

196 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
pasturer103752(None) 
pasture9311461pasture_
pastured1138231pastured
pasturers1136391pasturers
pastures10311961pastures
posturer1038921posturer
assurer767782_assurer
capturer1246082capturer
gesturer935982gesturer
maturer938972ma_turer
palterer102411272palterer
paster85734372past__er
pastier94320382past_ier
pastored1139962pastored
pastural1038412pastural
patterer103112172patterer
pesterer102412702pesterer
plasterer1178102plasterer
posture9313252posture_
postured1139492postured
posturers1137042posturers
postures10313762postures
abjurer1634743_abjurer
adjurer1534803_adjurer
allurer7348433_allurer
alterer72713993_alterer
aspirer967903_aspirer
assumer965363_assumer
assure6610773_assure_
assured858373_assured
assurers866303_assurers
assures7611403_assures
assuror754203_assuror
aster55434893_ast__er
astute6310763_astute_
augurer8136343_augurer
austerer838383austerer
banterer102811773banterer
barterer102711633barterer
baster85333593bast__er
batterer102713213batterer
capture1138903capture_
captured1336563captured
capturers1344633capturers
captures1239433captures
caster85232573cast__er
caterer92815933ca_terer
costumer1275103costumer
dasyure1153823dasyure_
dasyures1254153dasyures
disturber12165123disturber
easter65027983east__er
easterner945053easterner
ensurer73011903ens_urer
facture12108923facture_
factures13129023factures
falterer11239853falterer
fastener11227833fastener
faster94625773fast__er
favourer1443823favourer
fosterer11239513fosterer
fracturer14134623fracturer
gaster75027353gast__er
gastrea847223gast_rea
gesture839243gesture_
gestured1036993gestured
gesturers1044283gesturers
gestures9310013gestures
hastener11259133hastener
hastier103916623hast_ier
insurer73312803ins_urer
labourer1045753labourer
laster64830633last__er
lecturer10136023lecturer
manurer938583ma_nurer
masquer18266463masqu_er
master84831343mast__er
mastered112614003mastered
mature8313463ma_ture_
matured10310033ma_tured
maturers1037373ma_turers
matures9314303ma_tures
measurer1035953meas_urer
nastier74115293nast_ier
nature6311263na_ture_
natured838963na_tured
natures7311963na_tures
nurturer844473nurturer
obscurer1243523obscurer
oysterer1136103oysterer
palter84423263palt__er
paltered113012483paltered
palterers11249533palterers
paltrier1037523paltrier
pamperer14228333pamperer
panderer112210913panderer
panther12611443pant_her
paperer113111903pa_perer
parer75839903pa___rer
partaker1436873partaker
parterre1036983parterre
partier93520713part_ier
partner92811393part_ner
partyer12337873part_yer
parure8312523pa_rure_
parures9512693pa_rures
passer84721033pas__ser
passover13135533passover
passuses1036773passuses
paste74932953past__e_
pasted94426903past__ed
pastel85918713past__el
pastern94415063paster_n
pasterns104112623pasterns
pasters94531733paster_s
pastes85233913past__es
pasteurizer2252653pasteurizer
pastie85525523past_ie_
pasties94529813past_ies
pastime114611973pastime_
pastimes123611903pastimes
pastises103616053pastises
pastor84817483past__or
pastoral10310483pastoral
pastorly1345783pastorly
pastors94118993pastor_s
pastries101517423pastries
pastry114913033past_r_y
pasturage1244923pasturage
pasturages1344923pasturages
pasturing1238433pasturing
patcher143515143pa_tcher
pater74740723pa_t__er
patter84628263pa_t_ter
pattered112714203pattered
patterers112410123patterers
patzer173111643pa_t_zer
pauper103511943pa__uper
pauser84415963pa__user
peasouper1382193peasouper
perjurer17285903perjurer
perturber1343153perturber
pester84827593pest__er
pestered112814953pestered
pesterers112510443pesterers
pestier94317403pest_ier
pewterer13256313pewterer
piaster93012883piast__er
piastre9307893piast_re_
piastres10249303piast_res
picture1158613picture_
pictured1346573pictured
pictures1249343pictures
plaster93318693plast__er
plastered1288893plastered
plasterers1286123plasterers
poster84129173post__er
postural1049193postural
potterer102310263potterer
pourer84516043p__ourer
procurer1235833procurer
purer75127903p___urer
pustular1045153pustular
pustule937683pustule_
pustuled1134953pustuled
pustules1038443pustules
putterer10209913putterer
rapture937383rapture_
raptured1155463raptured
raptures1037573raptures
raster64731443rast__er
rasure6311423ras_ure_
rasures7312013ras_ures
restorer84813723restorer
savourer1134473savourer
sourer63620213__sourer
starer64027363__starer
storer64721673__storer
surer54833093__s_urer
tabourer1035743tabourer
taster64930573tast__er
tastier711817093tast_ier
torturer835493torturer
usurer638103_us_urer
vapourer1344263vapourer
vaster94521023vast__er
vastier103613203vast_ier
venturer1137243venturer
vesture10310373vesture_
vestured1237463vestured
vestures11311033vestures
wafture1334853wafture_
waftures1434853waftures
waster95228943wast__er
wastrel1037553wast_rel
waterer103314073wa_terer

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.1561145455.1
2DLD Change Limit1461621967.48619524.7
3Display Results1961960.0762578.9
 (SQL Overall)1786911967.71823152.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.