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

163 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
pasturing123843(None) 
pastoring12310851pastoring
posturing1238991posturing
assuring937772_assuring
capturing1436622capturing
gesturing1136652gesturing
mastering122315302mastering
maturing1139952ma_turing
paltering122612892paltering
pasting103826552past__ing
pattering122314422pattering
pestering122315662pestering
picturing1436032picturing
plastering1339242plastering
rapturing1245352rapturing
vesturing1337202vesturing
abjuring1834883_abjuring
adjuring1735103_adjuring
alluring939073_alluring
altering91917113_altering
aspiring1138873_aspiring
assuming1135143_assuming
astringe938223_ast_ringe
attiring939483_attiring
attuning935903_attuning
auguring1036383_auguring
bantering122414233bantering
bartering122313643bartering
basting104227203bast__ing
battering122715143battering
cantering122417373cantering
casting104628343cast__ing
castling11311233cast_ling
catering112019903ca_tering
cloturing1245473cloturing
costuming1445283costuming
culturing1236553culturing
disturbing1445653disturbing
easting84924303east__ing
ensuring9310173ens_uring
factoring1537523factoring
faltering132211113faltering
fastening13268603fastening
fasting114522833fast__ing
favouring1644023favouring
featuring1337323featuring
festering132413173festering
fissuring1344813fissuring
fostering132411263fostering
fracturing1643923fracturing
gartering112111573gartering
gasting95022763gast__ing
gastrin839833gast_rin_
gastrins9310123gast_rins
hachuring1845123hachuring
haltering132212003haltering
hamstring1546003hamst_ring
hastening13259483hastening
hasting114725193hast__ing
insuring9311153ins_uring
kashering1736253kashering
labouring1236213labouring
lasting84725243last__ing
lecturing1237303lecturing
lustering102711203lustering
lustring9269723lust_ring
manuring1139223ma_nuring
martyring1535783martyring
masting104325823mast__ing
mattering122314053mattering
measuring1236123meas_uring
mistuning1237673mistuning
mustering122212333mustering
nattering102212213nattering
nurturing1045013nurturing
obscuring1444023obscuring
oystering1337563oystering
pairing103716733pa__iring
pampering1638383pampering
pandering133211963pandering
panting104025423pant__ing
papering132213313pa_pering
paring94236493pa___ring
parring103222063pa__rring
partaking1698673partaking
parting103527383part__ing
partnering1345553partnering
parturient1245383parturient
partying14168893part_ying
pashing135120513pas__hing
passaging1345613passaging
passerine1147083passerine
passing104318423pas__sing
pastern94415063paster_n_
pasterns104112623paster_ns
pasteurise1244103pasteurise
pasteurising1552883pasteurising
pasteurize2143653pasteurize
pasteurizing2453383pasteurizing
pastina93914593past__ina
pastorium1347693pastorium
pastries101517423past_ries
pasturage1244923pasturage
pastural1038413pastur_al
pasture9311463pastur__e
pastured1138233pastur_ed
pasturer1037523pastur_er
pasturers1136393pasturers
pastures10311963pastur_es
patching163212753pa_tching
patining11312303pa_tining
patterning1346073patterning
patting103722343pa_t_ting
paupering1437273paupering
pausing103912813pa__using
peltering122011673peltering
perduring1336013perduring
perjuring1944923perjuring
perturbing1543563perturbing
pestling111010253pest_ling
petering112516813p_etering
pistoling1268493pistoling
plaistering1444603plaistering
plasterings1444743plasterings
pleasuring1343503pleas_uring
portering122012303portering
posting105622243post__ing
posturist11410443posturist
pottering122612003pottering
pouring103115863p__ouring
preassuring1443823preassuring
precuring1439423precuring
pressuring1346513pressuring
prestoring13310303prestoring
procuring1437993procuring
puncturing1543303puncturing
puttering122611643puttering
reassuring1155943reassuring
restoring10314613restoring
restring91518783rest_ring
rupturing1244353rupturing
savouring1335193savouring
sistering101213753sistering
souring83219063__souring
spattering13107793spattering
staring84527053__staring
storing83921123__storing
string75327563__st_ring
suturing9310373_suturing
tabouring1245723tabouring
tasting84624213tast__ing
tattering102212323tattering
texturing1735223texturing
torturing1036253torturing
unstring9312093unst_ring
upstaring1235963upstaring
vapouring1544653vapouring
venturing1337553venturing
waitering13310713waitering
wasting114422843wast__ing
watering122316313wa_tering
westering132112643westering
yattering132410443yattering

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.406440125.6
2DLD Change Limit1486411637.20320636.0
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.67223291.3
 
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.